LinkBack URL
About LinkBacks
I am trying to lookup my LOC with Item ID but Vlookup only brings up the first match of the array table. Is there any other formula in excel we can use to lookup the 2nd or 3rd possible items?
Great thanks in advance.
Book1.xlsx
I am trying to lookup my LOC with Item ID but Vlookup only brings up the first match of the array table. Is there any other formula in excel we can use to lookup the 2nd or 3rd possible items?
Great thanks in advance.
Book1.xlsx
Try this UDF:
Please Login or Register to view this content.
Last edited by ConneXionLost; 09-11-2012 at 06:01 PM.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Thanks for the UDF, but is there any user friendly formula that I can use without going into macro?
Thank you.
There isn't a user friendly formula, but you can use a pivot table to get what you're looking for.
If you're ok with a rather unfriendly formula, you can use this in cell E3 and copied down:
Please Login or Register to view this content.
Attached is a modified version of your example workbook that shows both methods.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
It worked!! Thank you very much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks