software

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.5A Cook
8A Craig
8B Innes
7.5B Kirby
8C 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

vlookup will do what you want but not in the cell that you actually type the
name,you can type a name in say a1 and have your value show up somewhere else
asuming the table you have demonstrated is in cells a2 to b6.The names
however must be in the LH column and the numbers to the right
your formula typed in b1 is =vlookup(A1,A2:B6,2,false).When you type A Cook
in a1
7.5 will show up in B1.The spelling must be exact however or you will get
the N/A error
--
paul
remove nospam for email addy!
quot;whatzzupquot; wrote:

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