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'!D4502)

The following returns "N/A:
=VLOOKUP(D3,'Assign Reps'!C4:C502,'Assign Reps'!D4502,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!!!!

 

[JE McGimpsey]

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'!C4502, 2, FALSE)

 

[Biff]

See reply in .Functions

Biff

 

[broadway05]

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'!C4502, 4, FALSE)" It just won't return
the correct value.

 

[broadway05]

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

=VLOOKUP(D3, 'Assign Reps'!C4502, 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?

 

[Peo Sjoblom]

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

 

[Ken Wright]

That's because you are still using the syntax incorrectly. You are
referencing a 2 column range C, 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
------------------------------­------------------------------­----------------

 

[Ken Wright]

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

 

[broadway05]

Thanks. That helped a lot!

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" <[email protected]>
wrote
in message