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