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!



"whatzzup" wrote:

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