Data Validation with IF and Max. Possible?

[Corey]

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....