Drop down list with cases on another page

[shepcs]

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]

 

[Norie]

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.