VLOOKUP formula

[SnoopRussyRuss]

Hi folks,

Excel newbie here - about to throw computer out window.

Trying to complete a VLOOKUP formula - but can't seem to get it right.

Here's a link to my worksheet:

Example of My Sheet

Columns A & B contain the name of a Club and the Club No.

Columns D through P contain a list of members and what Clubs they belong to. Many belong to several.

For each column D through P I want to take their club no; find a match in Column B and then place the corresponding value in Column A in Column Q (through to Column AD if they are members of multiple clubs.

Clearly my VLOOKUP syntax (example in Q2) is wrong.

Any assistance greatly appreciated.

Russ

 

[SnoopRussyRuss]

Sorry guys - the link above is correct - but doesn't seem to work when being embedded into the thread.

Here it is again:

https://masonica.co.nz/files/VLOOKUP%20problem.xlsx

 

[kevin9999]

Do you mean something like this?

VLOOKUP problem.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
1	Name	Club No.
2	The Hokianga Lodge	69		109	161												Lodge Manuherikia Kilwinning	The Research Lodge of Otago
3	The Kaikohe Ohaeawai Lodge	101		109	161												Lodge Manuherikia Kilwinning	The Research Lodge of Otago
4	Lodge Whangarei	102		402	801												Lodge Kerikeri	Not Found
5	Wellsford Marsden Lodge	169		25	225	800											The Woburn Lodge	Empire Fergusson Lodge	Not Found
6	Lodge Parahaki	269		25	225	800											The Woburn Lodge	Empire Fergusson Lodge	Not Found
7	Lodge Kororareka	304		64	189	381	415										The Fortitude Lodge	Lodge Waihopai	The Baden Powell Lodge	Research Lodge of Southland
8	Lodge Kerikeri	402		64	189	381	415										The Fortitude Lodge	Lodge Waihopai	The Baden Powell Lodge	Research Lodge of Southland
9	Lodge Hatea	431		64	189	381	415										The Fortitude Lodge	Lodge Waihopai	The Baden Powell Lodge	Research Lodge of Southland
10	Okara Daylight Lodge	461		64	189	381	415										The Fortitude Lodge	Lodge Waihopai	The Baden Powell Lodge	Research Lodge of Southland
11	The Ara Lodge	1		51													The Methven Lodge
12	Manukau Westmere Lodge	24		22													Lodge of Progress
13	The Belmont Albion Lodge	45		447													Lodge Homewood
14	The Ponsonby Lodge	54		17	416												The Coromandel Lodge	The Pakuranga Lodge
15	Lodge Wairoa	55		17	416												The Coromandel Lodge	The Pakuranga Lodge
16	United Masters Lodge	167		262	419												Trentham Lodge	Lodge Mangaroa
17	Lodge Waitakerei	170		262	419												Trentham Lodge	Lodge Mangaroa
18	Lodge North Harbour	182		97													The Mount Ida Lodge
19	Titirangi Mt Albert Lodge	204		153													Lodge Rotorua
20	Lodge Arawhaiti	267		323	456												The Research Lodge of the Taranaki Province	Lodge United Taranaki
21	Lodge Selwyn	274		323	456												The Research Lodge of the Taranaki Province	Lodge United Taranaki
Sheet1

Cell Formulas
Range	Formula
Q2:AC21	Q2	=IF(D2<>"",XLOOKUP(D2,$B$2:$B$185,$A$2:$A$185,"Not Found",0,1),"")

 

[SnoopRussyRuss]

Oh my gosh - yes that's exactly what I was after.

Thank you so much!

Regards,

Russ

 

[kevin9999]

Oh my gosh - yes that's exactly what I was after.

Thank you so much!

Regards,

Russ

You're welcome, and thanks for the feedback