Defined Names

Hi Guys,


I have a dropdown menu from which i choose pay codes like ISPD, PEM, and DEG.
I have defined these names with the appropriate values 77, 20 and 44 respectively.

when i try to multiply the paycode (ISPD) with the number of hours (3)
in the format below (so that the drop down list can be utilised)

=Product (F7,G7)

it returns 3 rather than 231

Please help!


Thanks

Ben

Assuming that F7 is the drop-down, you can try it like this:

=PRODUCT(INDIRECT(F7),G7)

or just:

=INDIRECT(F7) * G7

Hope this helps.

Pete