Results 1 to 9 of 9

Thread: Vlookup and Match problem

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 09-30-2022, 02:40 AM #3
    sandy666
    sandy666 is offline
    Sir Moderator sandy666's Avatar
    Join Date
    May 2018
    Posts
    240
    Rep Power
    8
    Code:
    =VLOOKUP(F$26,bk,MATCH($B$24,bkt,1)+1)
    your bk (table_array) doesn't contain DMG1 (lookup_value) - result: #N/A
    Last edited by sandy666; 09-30-2022 at 03:58 AM.
    sandy
    I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Vlookup, Index, Match formula needed for a search criteria
    By vikash200418 in forum Excel Help
    Replies: 0
    Last Post: 07-05-2017, 09:28 PM
  2. Convert All Vlookup formulas to Index-Match in a worksheet
    By littleiitin in forum Download Center
    Replies: 0
    Last Post: 03-17-2016, 06:50 PM
  3. InputBox OK and Cancel Button Problem
    By mackypogi in forum Excel Help
    Replies: 5
    Last Post: 05-30-2014, 12:20 AM
  4. Problem with line (row) in a macro
    By k0st4din in forum Excel Help
    Replies: 1
    Last Post: 03-19-2014, 07:59 AM
  5. Formatting Problem while copying data
    By princ_wns in forum Excel Help
    Replies: 3
    Last Post: 04-03-2012, 07:18 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules