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:
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:
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