David

That worked, many thanks

Gren

-----Original Message-----
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

David


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

.