i have a data list which indicates p.o. numbers in one column and the next to
it is the product and sku in another column etc. i want a formula that will
look for the p.o. number and then bring in the info that is with that p.o.
which is the product sku etc. for example if one p.o. has 5 items then that
p.o. is typed repeated 5 times so i need the formula to bring back those 5
items on a new sheet. hope this makes sense.