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