DLookup

[HarryT]

I have two tables, the first table has a %, the second table is a list of percentages with 4 columns (one for each quarter of the year, these fields are $$ values). The table looks like this... % Q1 Q2 Q3 Q4. The percentages in the lookup table are in incriments of .5% (ie. 20.0%, 20.5%, 30%, 30.5%, etc...). The first table percentages are calculated so they could be of any denomination (ie 20.2%, 20.8%, etc...). I am trying to lookup these values on my lookup table and return one of the Quarterly columns (ie Q1, Q2, Q3, Q4).

How do I lookup the calculated % on the first table to the second lookup table and return the Q1 column? Would you have an example of the appropriate syntax?

Thanks in advance for any help you can provide.

 

[Norie]

So are you actually trying to do some sort of 'fuzzy' match/lookup?

ie the values you lookup aren't actually in the lookup range but you want the nearest match?

 

[HarryT]

Yes, the actual value being looked up may not match exactly, I would like to return the nearest value. Thanks