Excel Workshhet column search

[Pepitoracing]

I am currently working two different worksheets in one workbook. Th
first sheet is labeled "PO DETAIL", the second is labeled "P
PRINTOUT". I want to be able to type a PO number from column A
DETAIL into a PO number cell in PRINTOUT and have the information fro
the row to populate the fields. If someone can somehow get me started
I think I can figure out the rest.

For example, if I type 1234 in the PO # cell on PRINTOUT, I want it t
search Column A in DETAIL and find that PO#. Once it has Identifie
What row it is in DETAIL, I would then want to use the rest of th
information in that row to populate the rest of the info like vendo
name , address, serial #, amount, Date, etc, etc. I hope I a
explaining myself correctly.

Please help me!
Thanks!!


Pepit

 

[Frank Kabel]

Hi
for entering the PO# use 'Data - validation - List'. See:
http://www.contextures.com/xlDataVal01.html

For populationg the other columns use VLOOKUP. e.g. something like
=VLOOKUP(A1,'PO Detail'!$A$1:$F$100,2,0)
in cell B1 of your second sheet. See
http://www.mvps.org/dmcritchie/excel/vlookup.htm
for more details about VLOOKUP