IF and VLOOKUP not working
=IF(IF(ISNA(VLOOKUP(O3:O301,T8:T13,1,FALSE)),"NA",VLOOKUP(O3:O301,T8:T13,1,FALSE)),"ABC",IF(IF(ISNA(VLOOKUP(O3:O301,U8:U24,1,FALSE)),"NA",VLOOKUP(O3:O301,U8:U24,1,FALSE)),"DEF",IF(IF(ISNA(VLOOKUP(O3:O301,V8:V14,1,FALSE)),"NA",VLOOKUP(O3:O301,V8:V14,1,FALSE)),"GHI",IF(IF(ISNA(VLOOKUP(O3:O301,W8:W14,1,FALSE)),"NA",VLOOKUP(O3:O301,W8:W14,1,FALSE)),"JKL"))))
Above query not working need help.
Please attach the sheet!
Cheers!
Deep Dave
Error Part in your vlookup, Lookup value should be single cell
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
File is attached. Please check.
In B3 cell
Formula:
Please Login or Register to view this content.
Drag it down..
Please don't keep duplicated data (In F9 & F10 cell)
Re: IF and VLOOKUP not working
Thanks it works fine.
Glad it helps you and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks