Lookup Criteria in wrong place

[scottylad2]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Number	Category		First Name	Last Name	Address	Town or City	Postcode	DOB	AAR	Cost	Paid Y/N	Status
2	839	Playing Member Student/21		Derek	Mack	154 Stoneybank path	Musselburgh	EH19 aiv	27/06/1965	45	35.00	Yes	Fully Paid Up
3	21493	Family Member Paying		Isabella	Mack	154 Stoneybank path	Musselburgh	EH19 aiv	13/06/1963	47	75.00	No	To Pay
4	3748	Playing Member		Wanda	Mack	78 Weymess Square	Prestonpans	EH10 fsn	05/02/1980	30	75.00	Yes	Fully Paid Up
5	21246	playing Member Under 18		dave	surname 11	138 Sighthill road	Wallyford	EH4 ihi	14/02/1996	14	25.00
6	3173	Family Member Paying		sammantha	surname 8	86 Buckston gardens	Musselburgh	EH1 mhp	16/06/1956	54	75.00
7	24710	Non Playing Member		chloe	surname 20	33 Buckston hollow	Wallyford	EH28 qxo	02/03/1970	40	35.00
8	4137	Family Member Paying		norma	surname 27	80 Pans walk	Edinburgh	EH22 xtr	27/07/1925	85		Not Returning
9	18646	Family member Paid by other		simone	surname 20	134 Ravenswood way	Prestonpans	EH9 ppz	09/06/1950	60	0.00	No	Fully Paid Up
10	22035	Family member Paid by other		stephanie	surname 57	77 Ravenswood Square	Wallyford	EH28 lwy	05/11/1944	65	0.00	Yes	Fully Paid Up
11	8028	Associate Member (Stoneyhill Comm Centre)		paul	surname 87	145 Stoneyhill hollow	Musselburgh	EH19 dso	20/02/1986	24	30.00	Yes	Fully Paid Up
12	20350	Playing Member Student/21		lynne	surname 6	124 Ravenswood court	Prestonpans	EH8 tev	08/11/1975	34		Not Returning
13	2249	Playing Member		paul	surname 99	114 Castle path	Wallyford	EH4 zkd	12/09/1922	87	75.00	Yes	Fully Paid Up
14	9163	Associate Member (Stoneyhill Comm Centre)		lynne	surname 40	40 Weymess way	Prestonpans	EH29 yof	28/06/1959	51	30.00	Yes	Fully Paid Up
15	12454	Non Playing Member		kevin	surname 18	134 Stoneyhill bank	Prestonpans	EH27 pnq	11/01/1956	54	35.00	Yes	Fully Paid Up
16	13089	Family Member Paying		dave	surname 98	75 Sighthill path	Prestonpans	EH8 eqc	12/10/1975	34	75.00	Yes	Fully Paid Up
17	15158	Non Playing Member		sammantha	surname 78	33 Stoneybank court	Wallyford	EH29 qgh	15/01/1976	34	35.00	Yes	Fully Paid Up
18	9376	Family member Paid by other		stuart	surname 91	93 Ravenswood street	Wallyford	EH13 qyv	26/06/1968	42	0.00	Yes	Fully Paid Up
19	18976	Playing Member Student/21		stewart	surname 46	76 Stoneyhill path	Edinburgh	EH18 eru	24/07/1951	59	35.00	Yes	Fully Paid Up
20	11829	Family Member 1 plus 2 under 18 Paying		keith	surname 41	35 Sighthill road	Wallyford	EH14 uuo	31/12/1943	66	50.00	No	To Pay
21	8307	Playing Member		chloe	surname 87	125 Princes court	Wallyford	EH10 svy	05/01/1937	73	75.00	Yes	Fully Paid Up
22	4747	Playing Member		steve	surname 49	63 Pans road	Edinburgh	EH23 kmh	01/08/1935	75	75.00	Yes	Fully Paid Up
23	23450	Family Member Paying		stuart	surname 95	66 Holby way	Prestonpans	EH26 wum	29/09/1966	43	75.00	Yes	Fully Paid Up
24	6597	Non Playing Member		charlotte	surname 38	4 Stoneyhill walk	Prestonpans	EH24 fww	11/02/1920	90	35.00	Yes	Fully Paid Up
25	5712	Playing Member Student/21		bill	surname 92	128 Sighthill gardens	Edinburgh	EH16 wpl	25/02/1986	12	35.00	Yes	Fully Paid Up
26
27		Playing Member Student/21	4		Filtered List below based on Formula
28
29		Playing Member Student/21	0	Derek	Mack	154 Stoneybank path	Musselburgh	EH19 aiv	23920	45	35	Yes	Fully Paid Up
30		Playing Member Student/21	0	lynne	surname 6	124 Ravenswood court	Prestonpans	EH8 tev	27706	34		Not Returning
31		Playing Member Student/21	0	stewart	surname 46	76 Stoneyhill path	Edinburgh	EH18 eru	18833	59	35	Yes	Fully Paid Up
32		Playing Member Student/21	0	bill	surname 92	128 Sighthill gardens	Edinburgh	EH16 wpl	31468	12	35	Yes	Fully Paid Up
33
34
35
36
37
For Mailing

Hop this doesn't display too big. The table above is a small made up sample of a much bigger data base of names in a membership list.
Everything above B27 is in a seperate sheet, and in B27 I have the membership categories stored in a drop down list.What the formula does is let me pull a membership from the drop down, and whatever category i show is then displayed below B27 in a filtered list.

What I'd like is to be able to move the members category to Column J, is there a way to tweak this formula so that it will still lookup the member category but also display the columns to the left as well?