- Nov 2, 2010
I'm putting together a master list of phone numbers across the US. In order to keep things neat, each state is on a different sheet. Rather than change the formula 50x, I'm curious how I could adapt this formula so that it reads the cell that indicates the state.
where 'xx' can be read in the [STATE] column of the destination table.