Hi

Assuming your data table is on Sheet1 in columns A:D and that you want to
pull the data across to Sheet2 starting in A2

On sheet2 cell B2enter
=IF(A2="","",VLOOKUP(A2,Sheet1!A:D,COLUMN(),0))
Copy across through C2:D2
Copy B2:D2 down the sheet as far as you require

COLUMN() returns the column number, 2 for B, 3 for C etc. so it is stepping
up the offset for you automatically, instead of you having to change the
formula to 2 then 3 then 4
--

Regards
Roger Govier

"Tiya" wrote in message
...
****al,
I have data like
Farmer _ID Name_1 Name_2
Link Path
100003 Kamadinni Shasappa E:\Sujeet\Kn100005.JPG
100005 Khaza Raz
E:\Sujeet\Kn100003.JPG
100017 Jagadal Laxman E:\Sujeet\kn100017.JPG

i want to match farmer ID with LinkPath with lastno.100005

I need like

Farmer _ID Name_1 Name_2 Link Path
100003 Kamadinni Shasappa E:\Sujeet\Kn100003.JPG

how to i match tham.

thanks
Tiya