Getting data from another worksheet

[sriddle]

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.

 

[Bernard Liengme]

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

 

[sriddle]

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