=INDEX(Sheet2!D1:D100,MATCH(G3,Sheet2!J1:J100,0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"SJW" wrote in message ...
|I am trying to build a worksheet which will search on data from sheet 1 from
| a column in sheet 2, and place the text result of an unknown intersection of
| sheet 2 back into sheet 1
| sheet 1:
| Line 125 (g3)
| Name "result"
| sheet 2:
| column J (contains line #)
| columb D (contains name)
|
| I'm trying to look for the line #, find the name in that row, and place the
| name into the cell on sheet 1.
|
|