Someone please help.
I have a workbook which contains the following information:

SKU Loc
191400 A1012
191400 A1015
191400 D6012
191400 E1019
191400 h1004

I have a seperate workbook which displays the sku once. When i use
vlookup it brings back the first loc in this example would be A1012,
however is there a formula where i can bring the second value back
(A1015). Please note that this workbook changes as do the cell values
so using =cell# is not an option.

Please help