predetermined answer in next cell
 

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

predetermined answer in next cell
 

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
---
"geenie" wrote:
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

predetermined answer in next cell
 

Thank you/ :-)

"Max" wrote:

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
---
"geenie" wrote:
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

predetermined answer in next cell
 

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"geenie" wrote in message
...
Thank you/ :-)