search for right

V

VilMarci

Hi all,

I wonder if there's any possibility to do the following without rearranging
my tables:

I'd like to look up an order number in a table, and get the price from two
coloumns _left_
So the order number is in C3 and I'd like to get the value in A3 and so on.
Vlookup does only to right...

Please advise,

Thanks,
Marton
 
B

Bob Phillips

=INDEX(A1:A100,MATCH(ord_num,C1:C100,0))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top