Hi,if you put the following in column a and column b,
A Cook 7.5
A Craig 8
B Innes 8
B Kirby 7.5
C Gouder 8

and you have the formula in cell c2: VLOOKUP(C1,A1:B5,2)
then when you can input the text in c1,e.g. a cook ,the corresponding value
will appear in cell c2,i.e.7.5

“whatzzup”???

> 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