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.