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
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 |