| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing the value of cell
In Excell 2007, I would like to put the names of customers in one cell and
when I chnage the customer I would like the amount in another cell to change. i.e. If cell A2 has xxx customer, I would like cell B2 to equal 18. When I change cell A2 to zzz customer, I would like cell B2 to equal 15. Which formula should I use for this and can you help me with the formula? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing the value of cell
If you have only two customers (or a few only) then use IF
=IF(A2="xxx", 18, IF(A2="zzz",15,"")) If you have a lot of customers then use VLOOKUP =VLOOKUP(A2,E:F,2,False) after entering Customer and Value combinations in Col E & F "George" wrote: In Excell 2007, I would like to put the names of customers in one cell and when I chnage the customer I would like the amount in another cell to change. i.e. If cell A2 has xxx customer, I would like cell B2 to equal 18. When I change cell A2 to zzz customer, I would like cell B2 to equal 15. Which formula should I use for this and can you help me with the formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing background colour when changing data in a cell | Excel Discussion (Misc queries) | |||
| Cell colors or text color changing when date in cell gets closer. | Excel Worksheet Functions | |||
| Changing one cell colour by inserting date in another cell | Excel Worksheet Functions | |||
| changing a cell to changing the link | Excel Worksheet Functions | |||
| how do i record changing cell data (cell is dde linked) | Excel Discussion (Misc queries) | |||
Linear Mode
