Let me explain the question again.

Looking for (A2) in Sheet1
The second is where you're looking for it (Crewlist K9:K33),
The third is what column I w'd like to pull back is C9
I Want an exact match.

At present I am using 2007 but I have to use this file in earlier version
also.


"Udayan" wrote:

dEAR aLL pLEASE hELP mE

In sheet1 Column C2 i have a formula which compare A2 value in sheet1 with
(B9) value in CrewList, if it is true return the value in C9.


=IF(ISNA(VLOOKUP(A2,CrewList!$B$9:$C$33,2,0)),"",V LOOKUP(A2,CrewList!$B$9:$C$33,2,0))

I just want to change instead of B9 to look up at K9


I changed the formula something like this and it is not working.
=IF(ISNA(VLOOKUP(A2,CrewList!$k$9:$C$33,2,0)),"",V LOOKUP(A2,CrewList!$k$9:$C$33,2,0))

Please help