In other words, you want to do a right-to-left lookup?

If that's the case then you can't use VLOOKUP. Try this:

=INDEX(Crewlist!C9:C33,MATCH(A2,Crewlist!K9:K33,0) )

--
Biff
Microsoft Excel MVP


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