I have a worksheet that I do every quarter for corporate that could really use some formulas.
Column D contains all the counties in a state (in alpha order).
Column K contains only the counties (in alpha order) in that state that we have sold to(counties we have not sold to are missing from the list).
Column L contains the amount sold to these counties
I need a formula to match up the county in Column D with the same county in Column K (if it is there) and then transfer the info in Column L to Column E.
If this is possible it would save me alot of time each quarter!
Thanks.
Column D contains all the counties in a state (in alpha order).
Column K contains only the counties (in alpha order) in that state that we have sold to(counties we have not sold to are missing from the list).
Column L contains the amount sold to these counties
I need a formula to match up the county in Column D with the same county in Column K (if it is there) and then transfer the info in Column L to Column E.
If this is possible it would save me alot of time each quarter!
Thanks.