Lookup value in a table from a different worksheet

D

da

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

Mike H

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.
 
D

da

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top