i have a sheet with identical tables from different States. i am trying to create a lookup that if the state matches(top row) then begin vlookup from that column. Please see below: thanks in advance!!
Georgia Iowa
Row Labels POPULATION Row Labels POPULATION
Fulton 920,581 10% Polk 430,640 14%
Gwinnett 805,321 8% Linn 211,226 7%
DeKalb 691,893 7% Scott 165,224 5%
Cobb 688,078 7% Black Ha 131,090 4%
Chatham 265,128 3% Johnson 130,882 4%
Clayton 259,424 3% Woodbury 102,172 3%
Cherokee 214,346 2% Dubuque 93,653 3%
Henry 203,922 2% Pottawatt 93,158 3%
Richmond 200,549 2% Story 89,542 3%
Muscogee 189,885 2% Dallas 66,135 2%
Hall 179,684 2% Clinton 49,116 2%
Forsyth 175,511 2% Warren 46,225 2%
Bookmarks