In A1:B5 I have this list
Becky 10.50 (so a1 has Becky, B1 has 10.50)
Mary 12.45
Jane 10.75
Bob 12.00
Allan 20.45
I selected A1:B5 and used Insert | Name | Create


In C1 I have type Becky (caps do not matter)
In D1 I have type 2.5
In E1 I have the formula =INDIRECT(C1)*D1 and it displays 26.25
I could format it to show £26.25

In C2 I have typed Bob and in D2 I enters 3, I copied the formula from E1 to
E2 it shows 36
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

<Jon Overton wrote in message ...
Soupnaz et al - I am trying to do the same as you I think. I am woefully
poor with Excel (basic formulas only) not sure I even know what a macro
is.... what I am trying to do is a gibe a name (say becky) a value, say
$10.80 so that whenever the name is typed in excel knows to multiply the
hours enetred next to it x becky.... any ideas gratefully received and
rewarded if you coem to Bath UK.....

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com