Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Want to input one character to cause related string to display in.
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. |
#2
|
|||
|
|||
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. . |
#3
|
|||
|
|||
Hi!
Are these unique letters in a separate column? If so, assume they're in column A, A1:A26 and the $$ amounts are in column C, C1:C26. Assume you enter the letter identifier "A" in cell H1: =SUMIF(A1:A26,H1,C1:C26) Biff -----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. . |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. . |
#6
|
|||
|
|||
Thanks Biff,
This worked too. See my reply to Jason!. "Peace of Christ be with you" "Biff" wrote: Hi! Are these unique letters in a separate column? If so, assume they're in column A, A1:A26 and the $$ amounts are in column C, C1:C26. Assume you enter the letter identifier "A" in cell H1: =SUMIF(A1:A26,H1,C1:C26) Biff -----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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is the format for an input cell? | Excel Discussion (Misc queries) | |||
can you input time (hh:mm:ss) without having to input the colon i. | Excel Discussion (Misc queries) | |||
Searching a cell for a certain character. | Excel Worksheet Functions | |||
Removing ' character from cells | Excel Discussion (Misc queries) | |||
How do I match two cells and input a value in a different cell? | Excel Worksheet Functions |