DEV Community

[Comment from a deleted post]
Collapse
 
peter profile image
Peter Kim Frank • Edited

The last part of the formula is to decide if we want to return an exact match or not. To return an exact match enter a 0 and the formula is complete. If for any reason you do not want an exact match enter a 1.

How often do you use the 1 option?

I'm slightly embarassed to admit that I have saved a little reference image for myself that I use every now and then:
reference search
reference itself

Collapse
 
helenanders26 profile image
Helen Anderson

In my 15+ years of driving Excel I've never had a reason to look for an inexact match. However ... looks like there are some use-cases:

Using VLOOKUP and inexact match to draw raffle tickets

Using VLOOKUP and The Price is Right