Lookup Function Referencing cells, not text values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to use the Lookup function to reference cell values, not just
hand-entered values.

For example:
Column A Column B
1 23
2 45
3 65
4 78
5 93

I then want to enter a value into cell A9 and have a lookup function in cell
B9 that looks like this:
=LOOKUP(A9,{A1,A2,A3,A4,A5},{B1,B2,B3,B4,B5})

The lookup function works by entering in the corresponding values by hand
into the cell:
=LOOKUP(A9,{1,2,3,4,5},{23,45,65,78,93})

But that's not what I need! I appreciate any help.
 
You can use simply

=LOOKUP(A9,A1:B5)

but it depends on the data and the results you require. This requires A1:A5
to be sorted ascending and will give a result where there is not an exact
match, so, given your example if A9 contains 2.5 the above will return 45
 
Back
Top