Hello
What is the formula for Lookup value in a table which is in different
worksheet?
thank you

Hi,

Without a description of what your trying to do all that can be offered is
general help and I suggets this.

Start your formula manually with

=lookup(

and then navigate to the lookup value (say) a1 of sheet 1 and Excel will
correctly input the syntax of

=lookup(Sheet1!A1

manualy enter the comma and then navigate again to the lookup vector and
once again Excel will enter the correct syntax for that range. Carry on until
the formula is complete
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"da" wrote:

Hello
What is the formula for Lookup value in a table which is in different
worksheet?
thank you

Thanks
Here is the formula which gives me error #Name
=VLOOKUP(C709,APD '[Roster]APD ROSTER'!B2:C445,3)
Value to l0ok up is in C709
Worksheet name is APD Roster
Range to lookup from is B2:C445
and the value to be searched is in column 3


"Mike H" wrote:

Hi,

Without a description of what your trying to do all that can be offered is
general help and I suggets this.

Start your formula manually with

=lookup(

and then navigate to the lookup value (say) a1 of sheet 1 and Excel will
correctly input the syntax of

=lookup(Sheet1!A1

manualy enter the comma and then navigate again to the lookup vector and
once again Excel will enter the correct syntax for that range. Carry on until
the formula is complete
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"da" wrote:

Hello
What is the formula for Lookup value in a table which is in different
worksheet?
thank you