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 -- and it is sorted). 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=516545

It's not the FALSE parameter - you're not using the VLOOKUP syntax. Take
a look in Help.

If I understand you correctly, this should work:

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

In article ,
broadway05
wrote:

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 -- and it is sorted). I am writing the formula in a cell on
the first page.

Help!!!!

See reply in .Functions

Biff

"broadway05" wrote
in message ...

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 -- and it is sorted). 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=516545

I substituted the number (in my case #4 -- actually, I tried all the
column numbers), but all I get is the "REF" response. e.g.:
"=VLOOKUP(D3, 'Assign Reps'!C4:D502, 4, FALSE)" It just won't return
the correct value.



JE McGimpsey Wrote:
It's not the FALSE parameter - you're not using the VLOOKUP syntax.
Take
a look in Help.

If I understand you correctly, this should work:

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

In article ,
broadway05
wrote:

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 -- and it is sorted). 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=516545

The following didn't work. It just returned "REF"

=VLOOKUP(D3, 'Assign Reps'!C4:D502, 4, FALSE)
Doesn't matter which column number I pick (2,3,4), I always get the
"REF" response. And yes, the search column is sorted. Any other
suggestions?



broadway05 Wrote:
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 -- and it is sorted). 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=516545

You are using it incorrectly, you are using a 2 column table (column C and
D) while you are trying to pull the value from column F (the 4 in the
formula), thus the error, if you want to pull the value form F you need to
include it in the table

=VLOOKUP(D3, 'Assign Reps'!C4:F502, 4, FALSE)

should work if there is a match, if not it will return #N/A!



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"broadway05" wrote
in message ...

The following didn't work. It just returned "REF"

=VLOOKUP(D3, 'Assign Reps'!C4:D502, 4, FALSE)
Doesn't matter which column number I pick (2,3,4), I always get the
"REF" response. And yes, the search column is sorted. Any other
suggestions?



broadway05 Wrote:
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 -- and it is sorted). 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=516545

That's because you are still using the syntax incorrectly. You are
referencing a 2 column range C:D, yet telling it to return data from the 4th
column in that 2 column range, hence the REF. Change the 4 to a 2.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"broadway05" wrote
in message ...

I substituted the number (in my case #4 -- actually, I tried all the
column numbers), but all I get is the "REF" response. e.g.:
"=VLOOKUP(D3, 'Assign Reps'!C4:D502, 4, FALSE)" It just won't return
the correct value.



JE McGimpsey Wrote:
It's not the FALSE parameter - you're not using the VLOOKUP syntax.
Take
a look in Help.

If I understand you correctly, this should work:

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

In article ,
broadway05
wrote:

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 -- and it is sorted). 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=516545

LOL - Hi Peo - I should have read the rest of the notes first before
replying above - just duplicated your answer.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Peo Sjoblom" wrote in message
...
You are using it incorrectly, you are using a 2 column table (column C and
D) while you are trying to pull the value from column F (the 4 in the
formula), thus the error, if you want to pull the value form F you need to
include it in the table

=VLOOKUP(D3, 'Assign Reps'!C4:F502, 4, FALSE)

should work if there is a match, if not it will return #N/A!



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"broadway05"
wrote in message
...

The following didn't work. It just returned "REF"

=VLOOKUP(D3, 'Assign Reps'!C4:D502, 4, FALSE)
Doesn't matter which column number I pick (2,3,4), I always get the
"REF" response. And yes, the search column is sorted. Any other
suggestions?



broadway05 Wrote:
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 -- and it is sorted). 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=516545

Thanks. That helped a lot!


Peo Sjoblom Wrote:
You are using it incorrectly, you are using a 2 column table (column C
and
D) while you are trying to pull the value from column F (the 4 in the
formula), thus the error, if you want to pull the value form F you need
to
include it in the table

=VLOOKUP(D3, 'Assign Reps'!C4:F502, 4, FALSE)

should work if there is a match, if not it will return #N/A!



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"broadway05"
wrote
in message
...

The following didn't work. It just returned "REF"

=VLOOKUP(D3, 'Assign Reps'!C4:D502, 4, FALSE)
Doesn't matter which column number I pick (2,3,4), I always get the
"REF" response. And yes, the search column is sorted. Any other
suggestions?



broadway05 Wrote:
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 -- and it is sorted). 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=516545



--
broadway05
------------------------------------------------------------------------
broadway05's Profile: http://www.excelforum.com/member.php...o&userid=31929
View this thread: http://www.excelforum.com/showthread...hreadid=516545