Hello,

I have created a drop down validation list for computer monitor types and
would like the cell below to display the monitor's power rating. Monitor
types used to generate the validation list and the power ratings for each are
taken from a different worksheet.

For example, if Sheet1.A1 contains a drop down list of monitor types taken
from Sheet2.Range(A1:A100), how do I set Sheet1.A2 to display the appropriate
power rating listed in Sheet2.Range(B1:B100)?

Hi,

If you would like to know how to create a dependent validation list, then
please visit the following link -
http://www.contextures.com/xlDataVal02.html

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Brutalius" wrote in message
...
Hello,

I have created a drop down validation list for computer monitor types and
would like the cell below to display the monitor's power rating. Monitor
types used to generate the validation list and the power ratings for each
are
taken from a different worksheet.

For example, if Sheet1.A1 contains a drop down list of monitor types taken
from Sheet2.Range(A1:A100), how do I set Sheet1.A2 to display the
appropriate
power rating listed in Sheet2.Range(B1:B100)?

I think what you should do is
Keep on with the way you have your drop down
list through the data validation and keep the list
as a single range on sheet,
However i would sugest to put the list in a column on
the same data entry sheet and then hide the column
much simple way espcial for only 100 rows.
OK so we have
col A (this is the drop down list)
col B (this would be the data need to fill the drop down
right click hide the column and then we will move on.
now you want the data in the drop down to return
a power figure related to the monitor choosen
One problem it have the data return in row and not
the next column, or at least when you try and
auto fill or copy out the formula you are going to be doing a lot
more work.
anyway.
Lets say col A is the drop down and the next col is the value return.
ok so we have

col a the drop down
col b the hidden list
col c copy and paste the same list
col d type in the corisponding info to the monitor
both of these col will then be hidden
col e this is were the value will render
use his formula
=vlookup(a1,$c$1:$d$100,2,FALSE)
hope this helps
if you want get ride of those #n/a's wright back

"Brutalius" wrote:

Hello,

I have created a drop down validation list for computer monitor types and
would like the cell below to display the monitor's power rating. Monitor
types used to generate the validation list and the power ratings for each are
taken from a different worksheet.

For example, if Sheet1.A1 contains a drop down list of monitor types taken
from Sheet2.Range(A1:A100), how do I set Sheet1.A2 to display the appropriate
power rating listed in Sheet2.Range(B1:B100)?