Makes sense and you could use a series of VLOOKUP formulas to return the data
based upon PO number chosen.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP


On Tue, 5 Jun 2007 08:34:09 -0700, veena
wrote:

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.