Like VLookUp True/Closest Match

[Mike The Newb]

I have two vlookups being done in Excel that I want to move to Access. One is
a closest match numeric and the other is a closest match alpha. For example:

The numeric:

Cell value is 3.250

Look Up Table:
1=A
2=B
4=C
8=D

I expect and receive a result of C, a cell value of 6.75 would return a D
and so on.

Alpha:

The cell value is MH

Look Up Table:

AC=Yadda1
FG=Yadda2
NP=Yadda3
RR=Yadda4

I expect and receive Yadda2, a cell value of OP would result in Yadda4 and
so on.

Both are your basic True within a vlookup (closest without going over). How
can I link two tables and achieve a closest without going over match in
Access?

Thank you for your and consideration.

Regards,
Mike

 

[Mike The Newb]

Correction: in the alpha example, expected result would be Yadda3 not Yadda4
- sorry for the confusion. Mike