Lookup
 

I need to lookup a value in a range that is not sorted.
Vlookup doesn't seem to do the job. I couldn't get Match
to do it either. How can I do that?

GMet

Lookup
 

Have you tried using 0 or FALSE as the third argument?
ie
=VLOOKUP(item,range,FALSE)
?

--
Return email address is not as DEEP as it appears
"GMet" wrote in message
...
I need to lookup a value in a range that is not sorted.
Vlookup doesn't seem to do the job. I couldn't get Match
to do it either. How can I do that?

GMet

Lookup
 

Jack,
That did it!! Thanks

GMet
-----Original Message-----
Have you tried using 0 or FALSE as the third argument?
ie
=VLOOKUP(item,range,FALSE)
?

--
Return email address is not as DEEP as it appears
"GMet" wrote in
message
...
I need to lookup a value in a range that is not sorted.
Vlookup doesn't seem to do the job. I couldn't get
Match
to do it either. How can I do that?

GMet


.