In sheet5 i am needing to setup ranges(A4:A13) and (A17:A26) with Data
Validation.
The data i want to populate the list is in Sheet4.

The user first Selects a Name from a Validation list in Cell B2.

Then when the user selects (each but not necesarily all) the (A4:A13) &
(A17:A26) data Validation lists ,
i want ALL values (Excluding Blanks) that are in Sheet4.Column (A) THAT ARE
Offset(1,-2) from the name chosen in B2 Validation List.


So in Sheet4 data is laid out like:

A B C D E F
G H I J
1 Name1
2 500
3
4
5
6
7
8 Name2
9 499
10


The Name value in Colum C ALWAYS has a 3 digit numerical value Offset(1,-2)
from it in Column A.
Is this possible ?
How?

Corey....

I'm not sure I understand what you need with the data validation, as far as
getting the offset of a value that was selected use Index and Match, you can
search here for examples that will show you how to find your data as well as
offsets.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Corey" wrote:

In sheet5 i am needing to setup ranges(A4:A13) and (A17:A26) with Data
Validation.
The data i want to populate the list is in Sheet4.

The user first Selects a Name from a Validation list in Cell B2.

Then when the user selects (each but not necesarily all) the (A4:A13) &
(A17:A26) data Validation lists ,
i want ALL values (Excluding Blanks) that are in Sheet4.Column (A) THAT ARE
Offset(1,-2) from the name chosen in B2 Validation List.


So in Sheet4 data is laid out like:

A B C D E F
G H I J
1 Name1
2 500
3
4
5
6
7
8 Name2
9 499
10


The Name value in Colum C ALWAYS has a 3 digit numerical value Offset(1,-2)
from it in Column A.
Is this possible ?
How?

Corey....