Look at VLOOKUP in help.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"caracasven" wrote in message
...
I work for a company that gives a certain mileage reimbursement to guys
working at certain jobs. I want to know how I can enter the name of the
job
and have the dollar amount of the reimbursement show up in the appropriate
column. Thanks!