List values based off of other list HLOOKUP

[Jona2491]

I have a list (data validation, list) based off of values "a b c" under which there other values. to visualize:

a b c
1 4 7
2 5 8
3 6 9

the first list, as i mentioned, is based off of "a b c". i want another to be composed of the values under the first list. so if in the first list i select "b", the second list will be "4-5-6", if i select "c" in the first list the second list will be "7 8 9" etc.

i tried HLOOKUP but failed quite miserably. any ideas?

Thanks

[martindwilson]

read here
http://www.contextures.com/xlDataVal02.html
why did you post this in access sub forum?