Vlookup

[Chris]

I use lookup to return an answer to cell m9. =lookup(B9,D120130) 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

 

[Dirk Goldgar]

I use lookup to return an answer to cell m9. =lookup(B9,D120130) 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.

 

[Jerry Whittle]

In Access we use DLookup. You should probably ask an Excel forum!