I just want to change instead of B9 to look up at K9
VLOOKUP(A2,CrewList!$k$9:$C$33,2,0)

Even though you have the lookup table defined as K9:C33 Excel evaluates it
as C9:K33. So, the formula is looking for the lookup_value in C9:C33 and if
found returns the corresponding value from the 2nd column of the lookup
table which would be D9:D33.

--
Biff
Microsoft Excel MVP


"Udayan" wrote in message
...
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