Help! need advice - search vlookup match index or something like?!

MET128

New Member
Joined
Mar 16, 2019
Messages
1
Hi all,

I have taken on a role as treasurer for the fundraising group (PTA) at my childs primary school. We run school events such as easter egg hunts and movie nights for the kids and the parents complete an online form to pay. I get a download of the childrens names which comes out in this format

Logan Amos
Katie Cooper
Isabella Clyne
Leah Dobbie
Cara Ali Kasir

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






The parents pay through online banking which comes out in this format:



Amos 2D
K Cooper RDS
Clyne 2AP
l Dobbie 1D
Ali Kair 3E

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





Is there any tool I can use to look up the childs name and bring back if they have paid? I am familiar with basic excel function vlookup but it only brings back the text for the whole cell. Is there any way to search for text within a cell as the cells do not match exactly?

I really hope so as I have hundreds of names to match up!!!
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Trebor76

Well-known Member
Joined
Jul 23, 2007
Messages
4,732
Hi MET128,

Welcome to MrExcel!!

You can try and set the range_lookup part of a VLOOKUP formula (last argument of the formula) to TRUE which will return approximate match but being only an approximate match the results will have to reviewed so closely you'd almost be better off doing it manually.

I could write a macro that would look in cell which should yield better results if you iike? I'd just need to know the sheet name(s) of where the names are and what columns they're in.

Thanks,

Robert
 

Watch MrExcel Video

Forum statistics

Threads
1,127,354
Messages
5,624,195
Members
416,017
Latest member
moritz210

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