Lookup partial match and return value.

[anil_l082218]

Hi there, New to Excel & VBA and i want to write a formula to bring Category & Subcategory from Table 2 to Table by partial lookup.
Simple vlookup with approximate match doesnt work and hence need to write something extra which i'm not sure of.
A simple formula or a VBA code is ok with me.
Really appreciate if someone can help on this code please. Many many thanks.
Rgds, Kumar

Sample.xlsx
	A	B	C	D	E	F	G
1	Table A - Have (Description) - Wanted Partial Lookup done from Table B and get Category & Sub Catg				Table B - For Lookup
2	Description	Category	SubCategory		Merchant	Category	SubCategory
3	OPAL MYTICKET	Auto & Transport	Public Transport		OPAL	Auto & Transport	Public Transport
4	BUNNINGS 775000	Services	Gardening		BUNNINGS	Services	Gardening
5	DOMINOS 4029357733	Food & Dining	Dining Out		DOMINOS	Food & Dining	Dining Out
6	ZAM PTY L	Food & Dining	Dining Out		ZAM	Food & Dining	Dining Out
7	SKYWATER 0288496164	Utilities	Water		SKYWATER	Utilities	Water
8	BANK ATM BRANCH				7 ELEVEN	Food & Dining	Coffee / Quickbites
9	7 ELEVEN LINKSYS PARK	Food & Dining	Coffee / Quickbites		IN SPORT	Personal Spending	Clothes & Shoes
10	IN SPORT TEXAS	Personal Spending	Clothes & Shoes		KMART	Household Items	Household Items
11	KMART DEPARTMENTAL STORE	Household Items	Household Items		DOMINOS	Food & Dining	Dining Out
12	DOMINOS PIZZA LINKSYS PARK	Food & Dining	Dining Out		ALDI	Food & Dining	Groceries
13	ALDI STORES LINKSYS PARK	Food & Dining	Groceries		PIE FACE	Food & Dining	Dining Out
14	KRISHNA TRADELINK PT				KFC	Food & Dining	Dining Out
15	PIE FACE CLARENCE ST	Food & Dining	Dining Out
Sheet1

 

[anil_l082218]

Please ignore this query guys.. I got the solution from some link.

 

[JEC]

=LOOKUP(1,000,FIND($H$6:$H$17,$D6),I$6:I$17)

 

[JEC]

Don't know how to change the last message but you have to delete the comma in 1,000. So it's just 1000