Assume I have a table as follows:

1 A
2 B
3 C
3 Ca
3 Cb
4 D

Currently, if I use =VLOOKUP(3,TABLE,2,FALSE) I'll get "Cb" as a return.
Anyway I can force VLOOKUP to return the first hit, i.e. "C"?

--
Thanks!
Max