Changing the value of cell

G

George

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?
 
S

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Change formulas in a column based on a selection. 3
Copying formulas across columns 2
Excel check value i cell 6
Conditional Formatting Driving Me Crazy 1
Concatenating two text strings, formula is right, cell output is w 3
conditional formatting on sales percentage 1
IF column B = anything in column A format 1

Top