Hi

You Could use the VLOOKUP Function

Something Like this

=VLOOKUP(A1,'Orders'!$A$2:$C$10,2,FALSE)

where A1 is the value you are looking up
'Orders'!$A$2:$C$10 is the table you are refrencing
2 is the number of columns along the data is that you Want to lookup
FALSE is so the Exact Value

HTH

Davi

--
Message posted from http://www.ExcelForum.com