Assuming that table is in A1:D26, with the single letter ID in column A, you
intend to type the single letter ID in K1 and get the dollars in L1, in L1 use
this formula: =VLOOKUP(K1,$A$1:$D$26,4,0)


On Sat, 19 Feb 2005 20:19:01 -0800, Peace of Christ be with you <Peace of
Christ be with wrote:

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.