Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter a name in one cell, and have it return their sales $.
I've spent a lot of time trying to figure this out and I just can't get it.
Basically I have a spreadsheet with names on it and their corresponding sales figures. Here is exactly what I have to do with those names and sales figures: I need an area of the spreadsheet where I can enter in an Employee name, and have the spreadsheet quickly display the total sales for that person. For example: Enter Name He Dave Kitson Total Sales: $229,793 Whenever a new name is entered, the total sales figure changes appropriately. I've been trying all kinds of reference and lookup formulas but I just can't get any to work. I don't even know for sure if I need to use a function for this or not. If it helps I've got my employee names listed in cells A12:A15 and their corresponding sales figures are in cells B12:B15. Thanks so much to anyone who can help me out with this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter a name in one cell, and have it return their sales $.
Hi Jordan - if I understand you correctly, you could input a vlookup in the
cell beside the cell that says "TOTAL SALES". It would lookup the name in the cell above it (in this example, cell D1 where D1 = Dave Kitson b/c that is what you entered into the cell) in column A and return the value tied to that name in column B - in this case, $229,793. Enter Name He Dave Kitson Total Sales: =vlookup(D1,A:B,2,false) -- Thank you! - Jennifer "Jordan D." wrote: I've spent a lot of time trying to figure this out and I just can't get it. Basically I have a spreadsheet with names on it and their corresponding sales figures. Here is exactly what I have to do with those names and sales figures: I need an area of the spreadsheet where I can enter in an Employee name, and have the spreadsheet quickly display the total sales for that person. For example: Enter Name He Dave Kitson Total Sales: $229,793 Whenever a new name is entered, the total sales figure changes appropriately. I've been trying all kinds of reference and lookup formulas but I just can't get any to work. I don't even know for sure if I need to use a function for this or not. If it helps I've got my employee names listed in cells A12:A15 and their corresponding sales figures are in cells B12:B15. Thanks so much to anyone who can help me out with this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter a name in one cell, and have it return their sale
Oh man, I can't believe it! That was it! Thanks so much Jennifer, that was
exactly what I needed. I had even tried the vlookup formula before, but I wasn't even close to entering the data properly. "Jennifer Cali" wrote: Hi Jordan - if I understand you correctly, you could input a vlookup in the cell beside the cell that says "TOTAL SALES". It would lookup the name in the cell above it (in this example, cell D1 where D1 = Dave Kitson b/c that is what you entered into the cell) in column A and return the value tied to that name in column B - in this case, $229,793. Enter Name He Dave Kitson Total Sales: =vlookup(D1,A:B,2,false) -- Thank you! - Jennifer "Jordan D." wrote: I've spent a lot of time trying to figure this out and I just can't get it. Basically I have a spreadsheet with names on it and their corresponding sales figures. Here is exactly what I have to do with those names and sales figures: I need an area of the spreadsheet where I can enter in an Employee name, and have the spreadsheet quickly display the total sales for that person. For example: Enter Name He Dave Kitson Total Sales: $229,793 Whenever a new name is entered, the total sales figure changes appropriately. I've been trying all kinds of reference and lookup formulas but I just can't get any to work. I don't even know for sure if I need to use a function for this or not. If it helps I've got my employee names listed in cells A12:A15 and their corresponding sales figures are in cells B12:B15. Thanks so much to anyone who can help me out with this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I enter a 4 in a cell & have it return 4:00 PM in Excel? | Excel Worksheet Functions | |||
Alt+enter to carriage return within a cell does not work...? | Excel Discussion (Misc queries) | |||
HOw do I use enter to return to the first cell in the next row? | Excel Discussion (Misc queries) | |||
Enter a formula to return a result from a cell | New Users to Excel | |||
how do I enter a RETURN (Enter) in a cell in EXCEL2003 | Excel Discussion (Misc queries) |