I have an issue with a IFVLOOKUP in my spreadsheet. It is working for all the codes that are added to an input sheet under "code" heading, except for 2 of the codes it is not pulling anything through. The data is held on the info sheet and has a range name. Any help on why it is not picking up the data for the codes 15577600 and 15579000 would be great. I just can't fathom out why it is not working!
I have attached a sample of the data.
Thanks!
Perhaps...
=IF(ISERROR(VLOOKUP(C5,INFO,2,TRUE)),"",VLOOKUP(C5,INFO,2,TRUE))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Plz see the attachment
Rgd
RT
If my answer(s) helped you, please add me reputation by click on *
In your example, the named range is INFO refers to a range located on the sheet named Data. And you don't have it in this workbook.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
You're using a Named Range, INFO. Make sure that it covers the all the rows in the search table.
It actually generates a #REF error as it relates to your live file/folder/drive.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks