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