Vlookup hassles

  • Thread starter Thread starter Alastair
  • Start date Start date
A

Alastair

Hello,
I was wondering how to lookup values to the right ,
instead of left of the column with the known variable in
it. This has me stumped!

Also I was wondering if anybody knows how to use a vlookup
function on a data table which has 1 column ascending and
1 descending. For presentation purposes the data must be
kept like it is and the numbers used have many decimal
places, so I cannot use the "false" range-lookup option,
which has been suggested to me already.

Thanks for your time, I will be very impressed if some one
knows the solution to these problems as they have plagued
myself and colleagues for many years.

Cheers

ALastair
 
One way:

=INDEX(A:A,MATCH(J1,B:B,FALSE))

Looks up the value in cell J1 in column B and returns the
corresponding cell in column A.
 
Back
Top