Hi

Wgen on sheet Worksheet 2 you have in range A2:A11 values 1,2,3,...,10, and
in range B2:B11 according values to return, then on Worksheet 1 into cell B1
enter the formula:
=VLOOKUP(A1,'Worksheet 2'!A2:B11,2,0)

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Andrew" wrote in 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