Limitation In VLookUp (Office XP)

[kun]

Hi

VLookup will stop at the first value it find and ignore the rest if there is another of the same value.
Is there a workaround to find two of the same value but with different content using two different workbooks, workbook 1 being the table where you want to see the input of the find value and workbook 2 being the range of value assigned. eg. Product A with 20 units locate in Shelf A and Product A with 5 units locate in warehouse?
thanks, kun

[HansV]

VLOOKUP returns a single value to a single cell. How would you expect it to return multiple values?

[sdckapr]

I am not sure exactly what you want/need. Could you elaborate?

If your goal is to use VLookup to get multiple items then see the custom function that I wrote and posted in
Re: Lookup more than one row (2000). Perhaps this code could be modified to do what you want...

Steve

[Matz]

Just wanted to say thats some cool code /custom function !

I'm sure that will come in handy as I have often wanted to get duplicate vales from a VLookup. I write 'temp' subs all the time - should have thought of making custom functions!!

Thanks Steve <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

[kun]

Steve,

Thanks you for the response. I haven't try your code I am wondering whether we can to use function : index and match or just index?

thanks, kun

[sdckapr]

It depends on what you want to try (my functions are for VLOOKUP or HLOOKUP, not for match)

Could you elaborate on what you are trying to do. I don't understand your intial question.

Steve