Need Help with Vlookup or some function where approximate match is possible

mrafiq44

New Member
Joined
Oct 14, 2015
Messages
20
I have a worksheet where last name and first name is in separate columns and then i have a worksheet with first, middle and last names in one column. Is it possible to find out whether the names in the second worksheet (all together) are located in the first worksheet where everything is separate. so i want to do an approximate match just in case the middle initial is throwing things off. any help would be greatly appreciated.
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,628
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
When talking about Vlookup approximate match means that if the value is not found it returns the value before it should be, approximate match requires the list be sorted.


for example
Excel 2010
FGH
11
22
33
44
55
66
77
879

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Sheet4

Worksheet Formulas
CellFormula
F8=VLOOKUP(8,H1:H8,1)

<tbody>
</tbody>

<tbody>
</tbody>




You will need to get the names in the same order to do what you want to do. We would need to see examples of your data to come up with any formula.
 
Last edited:

Forum statistics

Threads
1,144,392
Messages
5,724,078
Members
422,536
Latest member
Zeeshan53

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
Top