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 |