Vlookup

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I use lookup to return an answer to cell m9. =lookup(B9,D120:D130) gives me
16300. the value of b9 = 16327, looking in column d it finds D126 = 16300 and
in D127 it finds 16400. I need it to return D127 as the answer. At presant it
gives me D126. How can I get it to return the cell above insteed of the one
below.
Regards
Chris
 
Chris said:
I use lookup to return an answer to cell m9. =lookup(B9,D120:D130) gives
me
16300. the value of b9 = 16327, looking in column d it finds D126 = 16300
and
in D127 it finds 16400. I need it to return D127 as the answer. At presant
it
gives me D126. How can I get it to return the cell above insteed of the
one
below.


I suggest you post this question in one of the Excel groups. This one is
for discussion of Microsoft Access, the database program.
 
Back
Top