Hi guys. Need help please. I need to extract unique data with multiple but same id in v look up.
Problem is when i do the v look up, it only returns the first instance of the ID's and not multiple.
How can i get around this?
Hi guys. Need help please. I need to extract unique data with multiple but same id in v look up.
Problem is when i do the v look up, it only returns the first instance of the ID's and not multiple.
How can i get around this?
Could you post your workbook with desired result?
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There's an example here:
http://www.excelforum.com/excel-form...ell-value.html
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks