View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
geenie geenie is offline
external usenet poster
 
Posts: 4
Default 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