Lookup help

[james.halliwell]

Hi,
If this is possible it will save me hours upon hours of time, I have two tabs, Master and Lot Numbers, I knows vlookup will always return the first value it find but is there some sort of circular reference or something to get around this,

On the master tab I can have multiples product codes if I do, I want it to look up different lot numbers from the lot numbers tab, there can be loads of different lots but I only need it to return however many there is on the master tab


Many thanks

[DGagnon]

try using a helper column on the Lot Numbers sheet by adding a column at the begining and using something like this:

Please Login or Register  to view this content.

Then doing your lookup using the same logic on the main sheet:

Please Login or Register  to view this content.

see attached example:

[james.halliwell]

Can i personaly thank you for this, i wasnt even going to post this as i didnt think it was possible, Mate you are a life saver

cheers very much

[DGagnon]

any time, i appreciate the thanks, its good to be able to help someone.