Partial matching vlookup?

Status
Not open for further replies.
T

tonyjyoo

Board Regular
Joined
Aug 5, 2016
Messages
167
Is it possible to write formulas to perform a "fuzzy lookup" without installing the addin?

E.g. I have 2 columns with partial matches in the middle of each description, but varying numbers and texts before and after within the cell.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
Upvote 0
Status
Not open for further replies.

Similar threads

C
  • Question
Vlookup - Find partial match from the lookup_value
Replies
2
Views
151
Peter_SSs
Peter_SSs
B
  • Question
Array Formula with partial match.
Replies
3
Views
944
DanteAmor
DanteAmor
A
  • Solved
#REF! error when using INDEX MATCH
Replies
5
Views
136
Fluff
Fluff
E
  • Solved
Index/Match - Return value if partial text from cell contained anywhere in separate column
Replies
5
Views
2K
excelnewb221
E
W
  • Question
Using vlookup but with partially identical cells
Replies
1
Views
439
winds
W

Forum statistics

Threads
1,215,510
Messages
6,125,223
Members
449,216
Latest member
biglake87

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top