VLOOKUP False Problem

[broadway05]

I have a "LOOKUP" statement (without the "false" at the end) which doesn't always return the exact match (I guess it returns the closest match). I need an exact match or nothing. When I add "FALSE" to the end of the statement, Excel won't accept it. So I changed it to "VLOOKUP" and added the "False" and I get no returns except for "N/A." Why doesn't the false parameter work for me??

The following returns sometimes-exact responses:
=LOOKUP(D3,'Assign Reps'!C4:C502,'Assign Reps'!D4:D502)

The following returns "N/A:
=VLOOKUP(D3,'Assign Reps'!C4:C502,'Assign Reps'!D4:D502,False)

FYI, "Assign Reps" is my second page (which contains the column I'm searching). I am writing the formula in a cell on the first page.

Help!!!!

[Niek Otten]

Try this:

=VLOOKUP(D3,'Assign Reps'!C4:D502,2,False)

Please let us know the result

--
Kind regards,

Niek Otten

"broadway05" <[email protected]> wrote
in message news:[email protected]...
>
> I have a "LOOKUP" statement (without the "false" at the end) which
> doesn't always return the exact match (I guess it returns the closest
> match). I need an exact match or nothing. When I add "FALSE" to the
> end of the statement, Excel won't accept it. So I changed it to
> "VLOOKUP" and added the "False" and I get no returns except for "N/A."
> Why doesn't the false parameter work for me??
>
> The following returns sometimes-exact responses:
> =LOOKUP(D3,'Assign Reps'!C4:C502,'Assign Reps'!D4:D502)
>
> The following returns "N/A:
> =VLOOKUP(D3,'Assign Reps'!C4:C502,'Assign Reps'!D4:D502,False)
>
> FYI, "Assign Reps" is my second page (which contains the column I'm
> searching). I am writing the formula in a cell on the first page.
>
> Help!!!!
>
>
> --
> broadway05
> ------------------------------------------------------------------------
> broadway05's Profile:
> http://www.excelforum.com/member.php...o&userid=31929
> View this thread: http://www.excelforum.com/showthread...hreadid=516544
>

[Biff]

Hi!

Try this:

=VLOOKUP(D3,'Assign Reps'!C4:D502,2,False)

Biff

"broadway05" <[email protected]> wrote
in message news:[email protected]...
>
> I have a "LOOKUP" statement (without the "false" at the end) which
> doesn't always return the exact match (I guess it returns the closest
> match). I need an exact match or nothing. When I add "FALSE" to the
> end of the statement, Excel won't accept it. So I changed it to
> "VLOOKUP" and added the "False" and I get no returns except for "N/A."
> Why doesn't the false parameter work for me??
>
> The following returns sometimes-exact responses:
> =LOOKUP(D3,'Assign Reps'!C4:C502,'Assign Reps'!D4:D502)
>
> The following returns "N/A:
> =VLOOKUP(D3,'Assign Reps'!C4:C502,'Assign Reps'!D4:D502,False)
>
> FYI, "Assign Reps" is my second page (which contains the column I'm
> searching). I am writing the formula in a cell on the first page.
>
> Help!!!!
>
>
> --
> broadway05
> ------------------------------------------------------------------------
> broadway05's Profile:
> http://www.excelforum.com/member.php...o&userid=31929
> View this thread: http://www.excelforum.com/showthread...hreadid=516544
>

[Pete_UK]

If you are copying this down the column in your first sheet, you may
need to amend it to:

=VLOOKUP(D3,'Assign Reps'!C$4:D$502,2,False)

Hope this helps.

Pete