Hello,
Its bit easy, use formula as follows,
=VLOOKUP(A,B,C,D) , where,
A = cell no., where name to be searched is stored (e.g., A1, N56...)
B = look up range, select columns (e.g, B:C) *please note that the value to be looked for has to be in leftmost column
C= relative number of column (e.g, 2, 8....) If you select range D:H, then column D will be first and H will be fourth
D = False (So that it'll look for exact value)
Else, award it to me, let me do it quickly.
Thanks and Regards,
Swapnil