Drop down list with cases on another page

shepcs

Board Regular
Joined
Feb 2, 2003
Messages
53
Any help would be greatly appreciated.

I'm trying to make an inputs page where you make like a data validation drop down list to pick the Case (on another page), then I'm assuming I can just do a VLOOKUP or something like that based on the case name.

The cases are arranged on another sheet on top of one another. Case Name, then data, then another Case Name with its corresponding Data.

Inputs Page
Case choose for each month [LIST OF ALL CASES IN JAN COLUMN on other page]


ON ANOTHER SHEET
Jan Feb March APRIL
CASE1 Case 2 CASE3 CASE4
30 88 93 102
CASE5 CASE6 CASE7 CASE8
40 40 40 40

Many thanks![/img]
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,357
Office Version
  1. 365
Platform
  1. Windows
If that's the way the data is organised I'm not sure you'll be able to use data validation.

To use data validation using data from another sheet you need a named range.

And that named range normally needs to be a single column of data.

I don't quite see how your data could fit with that.:)
 

Forum statistics

Threads
1,181,103
Messages
5,928,077
Members
436,587
Latest member
Slicesofquince

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top