I suspect I need to use a different function but I am trying to lookup data and in one tab the city name is in one column, but the tab with the data the city names are spread out over manmy columns.
<colgroup><col><col span="3"></colgroup><tbody>
Location
Revenue
Expenses
Boston
150000...