Tomkat743 wrote:
I apologize for my misunderstanding of how this all works. I posted
the original question along with a couple of others and had no
response over a 24 hour period. I determined that I was unclear with
the information I was providing so I reposted. I received a response
that I tried to make work for me but couldn't so I reposted again. I
tried to map a table for my explanation but I'm not sure it comes
thru as a table. I also think Tom Ogilvy may be giving me the
corrected information but I still can't understand it enough to
implement it or it doesn't work for my senario. Thank you for the
explanation on how this site works I'm new to all this.

You're welcome. I learned it because someone explained it to me, so it's
the least I can do.

Do you think
you could explain the formula that Tom has given me if you think it
will work? Thanks very much.

\

I can explain that formula, but I don't think it's right for your
application. If you have one site, and therefore one scale of threshholds,
then the formula is fine. But you don't, so don't spend any more time on it
other than for your own edification.

My understanding is that you have multiple sites and each site has it's own
production level threshholds. You want to supply Actual Mileage, Production
Level, and Site and return Reimbursed Mileage. Look at the link I provided
and that I repeat below. If the method used in that link doesn't work, then
tell me specifically why. Tell what inputs I'm missing. Tell me what
inputs you've used that produce the wrong outputs.

Take a look here
http://www.dailydoseofexcel.com/arch...iable-lookups/.
I tried to interpret you explanations in "Not quite there". If I
missed something, please respond to this post. When I reply to a


--
Dick Kusleika
MS MVP - Excel
www.dailydoseofexcel.com