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.

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.

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.