Thanks Jason,
I was trying to figure out if the VLOOKUP would help but I didn't know how
to code it until I read the tutorial you sent me to. It works great. This is
the first time I've been in a usergroup and I'm amazed I got 2 guys helping
me out immediately! I thought it might take days to get someone to see my
question. This is great. Thanks.
"Peace of Christ be with you"

"Jason Morin" wrote:

You can do this using the VLOOKUP function. To learn how
to use it, see:

http://www.contextures.com/xlFunctions02.html

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a table with a long list of places (stores) in
one column, the mileage
from my home in the 2nd column and the money $ amount I
can claim as a
business expense for that # miles driven in the third
column. I added to the
left of the first column an unique identifier for each -
a single character
A through Z. I want to be able to input in another area
of the spreadsheet
one of those identifiers , and have it pick up the
corresponding $ amount and
display it in a cell next to the ID I input. Iwill be
making dozens of inputs
and will sum the amounts at the bottom. How can I do
this? Thanks for your
help.
.