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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks