predetermined answer in next cell

G

geenie

I have a list of short codes that are equal to a certain Commission Rate
Now when this code is entered in a spread sheet the number must
automatically apear in the blank cell next to it.
e.g.
A1 A2

WND 75
3GHH 25
GS2 15
KSB 100
3H320 20
 
M

Max

Assume codes (eg: WND, etc) will be entered in A1 down
Put in B1:
=IF(A1="","",VLOOKUP(A1,{"WND",75;"3GHH",25;"GS2",15;"KSB",100;"3H320",20},2,0))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
 

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

vlookup based on a different cell 3
Formula in a cell, keep the answer from going over a certain value 1
CountA, Subtotal and "move to the first cell in the next column" 1
click on part# in pulldown list fills description cell in next col 2
how to countif when using indirect cell 1
Using SUMIF Function with a named cell reference as value in CRITE 3
Do until? For next? Help 1
Autofit single cell text 3

Top