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
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
Bookmarks