|
VLOOKUP "False" Problem
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 |
VLOOKUP "False" Problem
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!!!! |
VLOOKUP "False" Problem
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 |
VLOOKUP "False" Problem
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 |
VLOOKUP "False" Problem
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 |
VLOOKUP "False" Problem
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 |
VLOOKUP "False" Problem
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 |
VLOOKUP "False" Problem
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 |
VLOOKUP "False" Problem
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 |
| All times are GMT +1. The time now is 09:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com