LinkBack URL
About LinkBacks
mahershams 
Hi, mahershams,
item has to be found in the first column of the search matrix (in your sample that should be Column E, not A). If it´s located in another column than the first one use Index/Match instead of VLookup.
Ciao,
Holger
Hi, mahershams,
item has to be found in the first column of the search matrix (in your sample that should be Column E, not A). If it´s located in another column than the first one use Index/Match instead of VLookup.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hello mahershams,
Pls find the attached file.
I think we can get answer using iferror, index,match
Hi Brandedadnan
Thank you very for your solution. But if you have time please explain why vlookup unable to retrieve the data.
Regards
Shams
Hi, Shams,
Altered formula for P2:I have no idea why your or mine vlookup command do not work
Formula:
=IFERROR(VLOOKUP(E2,Sheet1!$E$1:$AJ$8,29,0),"")
Have a look at the attachment - works fine for me.
Ciao,
Holger.
Hi
Holger
Thank you very much. It works now. I have put wrong index column.
Regards
Shams
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks