Return Value that corresponds to criteria by wildcard

[joand]

Is there a way I can return all items that correspond to a wildcard criteria. In column A, I have a list of student names; in column B I have listed specific values. In Column E, I have a list of lookup values (need to search by wildcard) that I need to search in Column A and if it locates items that fit into the criteria, returns the value in Column B and separated by ";" (in case it returns multiple values). Anyone got ideas?

 

[meldoc]

Hello

Try this, adapted from Domenic's solution see link below.

http://www.mrexcel.com/forum/showthread.php?t=565753

Follow the instructions provided regarding the code, and use the formula below.

Excel Workbook
	A	B	C	D	E	F
1	BAdamk	116		Query	Adam	116;594
2	AAdams	594		Query	Cho	674;813;928
3	Ari Choder	674		Query	Daniel	976
4	Chodrah Al	813
5	Tom Chols	928
6	bob	653
7	bob	8
8	Daniel	976
Sheet1

Excel 2010

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

 

[joand]

thanks meldoc. that's something i didnt know was possible.