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

Changing page numbers?? 0
Change the colour of a neighbouring cell 6
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Copy addition formula of non-consecutive horizontal cells 2
Mail Merge Directory Conditional Page Break 0
VBA Coding Help for Beginner 0
Excel does not accept text format! 0
Cumulative formula for word table 0

Top