Check out VLOOKUP. There is a tutorial he

http://www.contextures.com/xlFunctions02.html

HTH
Jason
Atlanta, GA

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