Defined Names

[Ben51]

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




Thanks

Ben

 

[Noodleski]

You say you have defined ISPD as 77, but how did you do that? Excel multiplies 1, since ISPD is the first value in the list, with 3.

 

[Ben51]

Hi Noodleski,

thanks for the reply,


I defined it in Formulas, Name Manager

I actually have many more in the dropdown list, it is the 20th value.

Thanks Ben

 

[FormR]

I actually have many more in the dropdown list, it is the 20th value.

Hi, presumably you already have a list of the codes somewhere in the workbook, why don't you add a column to this and put the values there instead of using named ranges.

You could then do something like this:

Excel 2013
	A	B	C	D	E	F	G	H
1	Code	Value
2	ISPD	77
3	PEM	20
4	DEG	44
5
6
7						PEM	3	60
Sheet2

Cell Formulas
Range	Formula
H7	=VLOOKUP(F7,$A$1:$B$4,2,0)*G7