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