Good Morning All
I am trying to create a formula or macro where i can assign an operative
name to a value such as
7.5 A Cook
8 A Craig
8 B Innes
7.5 B Kirby
8 C Gouder
Where i can type the name A Cook in a cell the value 7.5 appears instead and
same with A Craig.
Can i have a bit of help please??? Thanks