T
taxmom
Since my first issue was answered and resolved, I discovered I need to adjust
my lookup.
My current formula worked well: It is only searching for the city name.
=IF(ISNA(VLOOKUP("totals for city:
Autaugaville",alavlookupcity,4,FALSE)),"",VLOOKUP("totals for city:
autaugaville",alavlookupbycity,4,FALSE))
However, I not only need to find Autaugaville city It must be in
Autaugaville county in order for me to capture the correct amount Gross and
Tax amount collected for this city/county combination. I have range named
the county names.
How do I incorporate the county in this formula?
Thanks
my lookup.
My current formula worked well: It is only searching for the city name.
=IF(ISNA(VLOOKUP("totals for city:
Autaugaville",alavlookupcity,4,FALSE)),"",VLOOKUP("totals for city:
autaugaville",alavlookupbycity,4,FALSE))
However, I not only need to find Autaugaville city It must be in
Autaugaville county in order for me to capture the correct amount Gross and
Tax amount collected for this city/county combination. I have range named
the county names.
How do I incorporate the county in this formula?
Thanks