Results 1 to 9 of 9

Thread: Vlookup and Match problem

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 09-30-2022, 02:40 AM #1
    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
  2. 09-30-2022, 12:16 PM #2
    DocAElstein
    DocAElstein is online now
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    Quote Originally Posted by sandy666 View Post
    Code:
    =VLOOKUP(F$26,bk,MATCH($B$24,bkt,1)+1)
    your bk (table_array) doesn't contain DMG1 (lookup_value) - result: #N/A
    Hi there
    I don’t understand?
    I thought this was table bk ?
    https://postimg.cc/mthjqfLQ https://i.postimg.cc/Hs9NrdFP/bk-Table-data-A1-M13.jpg


    What am I missing?
    Last edited by DocAElstein; 09-30-2022 at 12:23 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
     Winston Churchill, 1939
    Save your Forum..._
    KILL A MODERATOR!!
    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