index/match multi columns as if it were one column

[dfida]

Hi,

I have several columns, each of which may be in separate tabs.
I am wondering if there is a way to index/match them as if they were just one long column?

Excel Workbook
	B	C	D	E	F	G
8	POOLE	HARRINGTON	GREGORY	JOHNSON	FLANAGAN	TAYLOR
9	FOUNTAIN	MURPHY	SMITH	VEAL	FLECK	HOPS
10	BARTHOLOMEW	LOPEZ	EVERTS	RICHARD	BURTON	GRAY
11	MARION	EVANS	LYONS	SURPRISE	WALKER	QUIGLEY
12	DURAN	DUFFIN	BALL	CARTER	LARSEN	RILEY
13	SINCLAIR	SMITH		LOWRIE	KRAMER	WALL
14	HALL	PRYOR		BELL	RANDALL	SIMPSON
15		MCEVERS		BRUNSON	FERGUSON
16		SHAW		CASANOVA	GALLOWAY
17		CARLSON		CUNNINGHAM
18		HARRISON		BYRD
19		HUTCHINSON		ROY
20		MCDONNELL		BOSLEY
21
22
23
24
25
26
27	ROW	COLUMN	INDEX/MATCH
28	1	1	POOLE
29	8	1	HARRINGTON
30	22	1	SMITH
Sheet1

Excel 2007

 

[dfida]

Then it should work. What formula did you use with it?

The one you suggested:
=INDEX(ARRAYJOIN(B8:B14,C8:C20,D8:D12,E8:E20,F8:F16,G8:G14),B28)

So, it seems to not recognize "arrayjoin".

 

[jasonb75]

Is the module with the code in the same workbook at the formula?