Since you're returning the second column in the range (hence, the ,2,0), you
must really mean that you want to look up from columns K to L, not K to C.
Like this:

=IF(ISNA(VLOOKUP(A2,CrewList!$k$9:$L33,2,0)),"",VL OOKUP(A2,CrewList!$k$9:$L$33,2,0))

I guess what you're saying is that your list of information (the crew list)
is now in K9:L33 rather than from B9:C33, correct? Remember, the first thing
is what you're looking for (A2), the second is where you're looking for it
(Crewlist K9:L33), the third is what column you'd like to pull back (column
2, or the L column), and last is whether or not you want an exact match.

Just so you know, if you're in Excel 2007, you can now use the handy IFERROR
function and can shorten your formula to:

=IFERROR(VLOOKUP(A2,CrewList!$K$9:$L$33,2,0),"")

Happy calculating!

If you like this answer, please click ''Yes.''




"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