This will return the value in A1 of Sheet2: =Sheet2!A1
This will do a lookup or the value in A1 of sheet1 in the table on sheet2
and return the item from column 2
=VLOOKUP(A1,Sheet2!A1:B10,2,0)

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"sriddle" wrote in message
...
I need to get data from one line on a worksheet to match the entry on a
drop
down list from another worksheet with values changing according to the
name
on the drop down list.