| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FALSE argument in VLOOKUP
I have a spreadsheet with the following VLOOKUP formula:
=VLOOKUP(U4,Sheet1!$A$1:$E$509,3,FALSE) What does the FALSE argument do? -- Brevity is the soul of wit. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FALSE argument in VLOOKUP
It looks for the exact match, if not found it will return #N/A, if omitted
or replaced with TRUE it will be looking for the lesser closest match or exact match, however the lookup range needs to be sorted in ascending order for that option, if not it will return the wrong value or #N/A. Note that FALSE and TRUE can be replaced with 0 and 1 in the formula -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Dave F" wrote in message ... I have a spreadsheet with the following VLOOKUP formula: =VLOOKUP(U4,Sheet1!$A$1:$E$509,3,FALSE) What does the FALSE argument do? -- Brevity is the soul of wit. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FALSE argument in VLOOKUP
Helpful, thanks.
-- Brevity is the soul of wit. "Peo Sjoblom" wrote: It looks for the exact match, if not found it will return #N/A, if omitted or replaced with TRUE it will be looking for the lesser closest match or exact match, however the lookup range needs to be sorted in ascending order for that option, if not it will return the wrong value or #N/A. Note that FALSE and TRUE can be replaced with 0 and 1 in the formula -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Dave F" wrote in message ... I have a spreadsheet with the following VLOOKUP formula: =VLOOKUP(U4,Sheet1!$A$1:$E$509,3,FALSE) What does the FALSE argument do? -- Brevity is the soul of wit. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP - WISH TO SUBSTITUTE FALSE FOR A VALUE | Excel Discussion (Misc queries) | |||
| Stop renaming or moving sheet tabs | Excel Discussion (Misc queries) | |||
| Drop down lists and vlookup? or Match? | Excel Worksheet Functions | |||
| Grouped Sheets and Formating | Excel Discussion (Misc queries) | |||
| Grand Totals @ Same Place | Excel Worksheet Functions | |||
Linear Mode
