search for right

  • Thread starter Thread starter VilMarci
  • Start date Start date
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
 
=INDEX(A1:A100,MATCH(ord_num,C1:C100,0))

--

HTH

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