Substitute for VLOOKUP with “1” or True?

**artistdedigital** · 12-03-2014, 11:49 PM

Hi all,

I have a vlookup question here. It seems VLOOKUP is a wonderful tool when there is an absolute 100% match and used with condition False or “0”. But it is totally useless when vlookup is used with condition true or 1 it is total clueless and returns basically anything.

Is there a better formula to control the cluster of strings I want to find when I do not have an absolute 100% match but I still want to find out the match between 60% - 90%?

Thanks heaps.
Cheers to all.

**:) Sixthsense :)** · 12-04-2014, 12:14 AM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**FDibbins** · 12-04-2014, 12:34 AM

But it is totally useless when vlookup is used with condition true or 1 it is total clueless and returns basically anything.

Not so. The TRUE condition is used when you have a sorted list. If the actual value cannot be found, vlookup returns the next-closest value lowest value. In other words, if it cannot find an exact match, it will search until it gets to a value that is the 1st value greater than what you want, then return the value just below that 1

**artistdedigital** · 12-07-2014, 07:26 PM

Thanks guys. I am attaching a sample dataset with desired results. The required informations also in the spreadsheet. Cheers.

**Debraj Roy** · 12-07-2014, 07:33 PM

Is this somehow matching your requirement..

http://www.mrexcel.com/forum/excel-q...planation.html

**artistdedigital** · 12-08-2014, 06:33 PM

Originally Posted by Debraj Roy

Is this somehow matching your requirement..

http://www.mrexcel.com/forum/excel-q...planation.html

Thanks heaps Debraj...You are a saviour...Cheers mate...

**artistdedigital** · 12-08-2014, 08:41 PM

Hey Debraj,
I have tried the FuzzyVlookup but it did fail in the sample spreadsheet? Would you mind having a look and help me what am I doing wrong? It did seem to work but not finding the desired result? Thanks again mate. Cheers.