Vlookup same value but two different outcomes

Hi guys so i am trying to work out how to do it, but how would i go about using vlookup to look for a value with two different outcomes.

so if in A2 and A3 is a product code of 50022261 and in k2 and k3 i want to put vlookup to look up that product code on another sheet and return both locations how would i do so? as whatever i do it returns the same location.

Currently using

Please Login or Register  to view this content.

but obviously getting the same outcome.

ill be using vba to paste the formula down column k to like 15,000 cells & then copy n paste values after.

ill attach a sample workbook of the part im stuck on, thanks

As they have the same product number, is there anything on the Outcome sheet that can be used differentiate those two products on the MERCH sheet?
For example the MERCH sheet has 'A' against the first product and 'B' against the second, can something like that be added to the Outcome sheet to allow for a unique match?

How about

Formula:

Please Login or Register  to view this content.

Worked perfectly, thanks!

You're welcome & thanks for the feedback