Hi All,

I'm only new to Excel macro/query building (Microsoft Infrastructure man)
but i have an issue with a clients spreadsheet and was wondering if its
posible to solve.

Question.

If i'm using a validated list column preforming a look up of another
worksheet for its value, if i select on of the ilst options can i bring back
in another field related fields to this value?
In excel terms - Worksheet 1 Row 1 Column A has a validated list contain
1,2,3,4.....10. If i select 1 i want to bring back in Row 2 Column B related
fields to this value which are true, false, end and start. These fields are
specified in worksheet 2.
I have been informed by othre chat groups that this is possible but no one
knows how?
Is this possible?? If so what is the macro/VB scripting needed to provide
this solution??
Is there a better approach??

Andrew