question about drop down lists and values.

[DARKDRAGON1142]

so im working on a project to calculate items i need to reach a certain number. what i want is to be able to slect a drop down list to say be level 60-62 for the list. then have the 60-62 represent a number something different like 7,777. so basically when i select 60-62 that essentially stands for 7,777 and will be represented by my selection of 60-62.

is there a way to tie what i select from a drop down list to a secondary value that would be represented in the cell once its selected?
[TABLE="width: 487"]
<tbody>[TR]
[TD="width: 230"]item[/TD]
[TD="class: xl68, width: 76"]exp[/TD]
[TD="class: xl68, width: 74"]level range[/TD]
[TD="class: xl68, width: 95"]leves required
[/TD]
[/TR]
[TR]
[TD]1 Enchanted Koppranickel Ink[/TD]
[TD="align: right"]916164[/TD]
[TD]60-62[/TD]
[TD="class: xl67"]value
[/TD]
[/TR]
</tbody>[/TABLE]


where i want 60-62 to represent a number and be divided by the value under exp and the resulting number be represented under leves required.

 

[rpaulson]

create a vlookup table

 

[DARKDRAGON1142]

create a vlookup table

im assuming thats basically just a table then referencing it using the name manager? if not could you give and example minor one would be fine.

 

[Perpa]

im assuming thats basically just a table then referencing it using the name manager? if not could you give and example minor one would be fine.

DD1142,
Welcome to the Forum.
So in the example below you would have Data Validation in D3 from which to select the 'level range',
and the VLOOKUP formula in E3 =VLOOKUP($D$3,$H$3:$I$11,2,FALSE)
To apply Data Validation in Cell D3: Select the Hometab>Data>Data Validation, then
Allow >List > for the Source enter this formula:
=OFFSET($H$3,0,0,COUNTA($H:$H))
This formula will always include the last value in column H.
You can modify these formula to suit your data.
Perpa

Sheet1

	A	B	C	D	E	F	G	H	I
Quantity

<tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]1
[/TD]

[TD="align: center"]Enter
[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]2
[/TD]

[TD="align: left"]item
[/TD]
[TD="align: center"]exp
[/TD]
[TD="align: center"]level range
[/TD]
[TD="align: center"]levels required
[/TD]

[TD="align: left"]level range
[/TD]
[TD="align: left"]levels required
[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]3
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: left"]Enchanted Koppranickel Ink
[/TD]
[TD="align: center"]916164
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]54-56
[/TD]
[TD="align: center"]5,555
[/TD]

[TD="align: center"]42-44
[/TD]
[TD="align: left"]1,111
[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]4
[/TD]

[TD="align: center"]45-47
[/TD]
[TD="align: left"]2,222
[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]5
[/TD]

[TD="align: center"]48-50
[/TD]
[TD="align: left"]3,333
[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]6
[/TD]

[TD="align: center"]51-53
[/TD]
[TD="align: left"]4,444
[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]7
[/TD]

[TD="align: center"]54-56
[/TD]
[TD="align: left"]5,555
[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]8
[/TD]

[TD="align: center"]57-59
[/TD]
[TD="align: left"]6,666
[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]9
[/TD]

[TD="align: center"]60-62
[/TD]
[TD="align: left"]7,777
[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]10
[/TD]

[TD="align: center"]63-65
[/TD]
[TD="align: left"]8,888
[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]11
[/TD]

[TD="align: center"]66-68
[/TD]
[TD="align: left"]9,999
[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula E3 =VLOOKUP($D$3,$H$3:$I$11,2,FALSE) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4