I did post this before and realize I may not have given enough info...

Sheet 1
PO# Date Total Tax ShipTo
20065 1/06 100 10 IMT
20066
20041
20048

Sheet 2
Date PO# SalesPerson Total Tax
1/06 20041 Bob (populate these two from Sheet1)
20065
20066

I have two sheets. Not in the same order (column not row.) Can I populate
the Total and Tx columns from Sheet1 with a look up???

I have tried VLOOKUP, but the ONLY row that works is the first.

Thanks in advance!!!