lookup function not getting needed results

ref. attachement. PTP TEST.xlsx

I am using lookup function in Sheet1's B,C,D,E,F columns to bring data from sheet MASS. The data is more than 1341 rows. But the formula / function is not bringing correct results. For example cell F2 is filled with wrong entry.
Please help.

You don't seem to have exact matches in your sheet. If you do in your actual data, you're better off using an INDEX/MATCH combo rather then LOOKUP which requires results to be sorted in an ascending order

=INDEX(mass!D:D,MATCH($A2,mass!$A:$A,0))

Change the column reference for varied results

Originally Posted by Ace_XL

You don't seem .........aried results

// LOOKUP which requires results to be sorted in an ascending order //

I know this now only.

Thanks a lot. It solved.