Re: Want to input one character to cause related string to display

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Peace of Christ be with you (PeaceofChristbewithyou_at_discussions.microsoft.com)
Date: 02/20/05 

Date: Sat, 19 Feb 2005 22:13:02 -0800

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 spread***
> >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.
> >.
> >
>

Quantcast