LinkBack URL
About LinkBacks
Hi,
I have written a vlookup formula, and all fields are correct, but it return no value.
Can any body advise reason
Vlook up return no data
Hi,
I have written a vlookup formula, and all fields are correct, but it return no value.
Can any body advise reason
No
We need more information
Wheres the formula for one?
Maybe include the workbook so we can look into it?
Please supply a desensitized version of your spreadsheet. There could be 100 reasons it isn't returning anything.
Is it looking from left to right and not right to left?
Thanks,
Formula in sheets 1 for reference data in sheet 2
Try changing to
=IFERROR(VLOOKUP($B2,Sheet2!$C$2:$C$39,1,FALSE),"")
=IFERROR(VLOOKUP($B2,Sheet2!$B$2:$C$39,1,FALSE),"") is trying to find "adnan" in a column that is all numbers.
Edit It appears you are trying to return ID numbers. VLOOKUP searches left to right. You are trying to work this right to left.
You need INDEX/MATCH for this. It is more flexible.
Try
=IFERROR(INDEX(Sheet2!$B$3:$B$39,MATCH($B2,Sheet2!$C$2:$C$39,0)),"")
Last edited by FlameRetired; 07-14-2017 at 01:11 AM.
Dave
Thanks alot it worked
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
You're welcome. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks