FALSE argument in VLOOKUP

[Guest]

I have a spreadsheet with the following VLOOKUP formula:

=VLOOKUP(U4,Sheet1!$A$1:$E$509,3,FALSE)

What does the FALSE argument do?

 

[Peo Sjoblom]

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)

 

[Guest]

Helpful, thanks.
--
Brevity is the soul of wit.

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)