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.

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.

Thank you so much, that really got me going in the right direction