Trouble with VLookup & Match Formula

[seenfresh]

I am having trouble with a VLOOKUP with multiple dependants, maybe someone could help me or notice what I am doing wrong.

I am trying to VLOOKUP:

The first Display[1] shows a partial list of stations in column A and trimed in column F for VL purposes

In the second Dispay[2] I would like to VLookup from Display[1] to Display[2] based on these dependencies:

1) Search all of column A and match station name in A134 "WBAY" with "WBAY" in A 352 (must be the last occurance because of next dependencies)
2) Match C134 with C352
2) Then match find the last date in column F thus 8/31/2006
3) Then if all these hold true in the same row as the A134 -> A352 station name match return value from column M

I have this function but it returns #N/A could anyone spot a problem with this?

=VLOOKUP(C134,INDEX(D$320:D$1000,MATCH(A134,A$320:A$1000,0)):INDEX(M$320:M$1000,MATCH(A134,A$320:A$1000)),10)


Sorry about the Essay!

If anyone could help I would remember you when I buy my next Lottery Ticket!

This board is awesome!

Thanks,

Sean

Akamai_Aug_Report3.csv
	A	B	C	D	E	F	G
134	WBAY	DataFinal	EdgeSuiteDeliveryEdition	NetStorage		ABCG	#N/A
135	WBDC	DataFinal	EdgeSuiteDeliveryEdition	NetStorage
136	WBKO	DataFinal	EdgeSuiteDeliveryEdition	NetStorage
137	WBNS	DataFinal	EdgeSuiteDeliveryEdition	NetStorage
138	WBOC	DataFinal	EdgeSuiteDeliveryEdition	NetStorage
139	WBTV	DataFinal	EdgeSuiteDeliveryEdition	NetStorage
Akamai_Aug_Report3

Akamai_Aug_Report3.csv
	A	B	C	D	E	F	G
134	WBAY	DataFinal	EdgeSuiteDeliveryEdition	NetStorage		ABCG	#N/A
135	WBDC	DataFinal	EdgeSuiteDeliveryEdition	NetStorage
136	WBKO	DataFinal	EdgeSuiteDeliveryEdition	NetStorage
137	WBNS	DataFinal	EdgeSuiteDeliveryEdition	NetStorage
138	WBOC	DataFinal	EdgeSuiteDeliveryEdition	NetStorage
139	WBTV	DataFinal	EdgeSuiteDeliveryEdition	NetStorage
Akamai_Aug_Report3

 

[seenfresh]

I'm gonna have to send you it tommorrow, hope that's cool!

Heading out for the day!

Thanks Again

Sean

 

[Domenic]

That's fine, no problem...