Getting/Searching Cell value from another Excel Worksheet

[Kayd]

Thanks for your reponses guys,

benzadeus,
The function you wrote, where do i specify the workbook name for example; like i mentioned i want to call workbook 2 from workbook 1 (vba Code).
In otherwords i am working on 2 excel spreadsheets

Mark,
for workbook 2, i want to search for a value in coloumn B, hoping to get the row number of a match, then get that value of that row # in coloumn D.
Hope that makes sense guys. Thnx