I need a formula that will display values based on content in another cell. Cell M4 will have a value of either San Mateo or San Jose. (It actually isn't a hard coded value but is pulling a value based on a pivot table) In the cell where my formula will be, I need it to display 1 if the value in M4 is San Mateo or 2 if the value in M4 is San Jose.
Something along the lines of this: =IF(M4=San Mateo,"1",IF(M4=San Jose,"2")) which doesn't work, but this does =IF(M4=SanMateo,"1",IF(M4=SanJose,"2"))
Because other cells are dependent on M4 reading San Mateo vs SanMateo, I need a workaround.
Any ideas?
Thanks in advance
Something along the lines of this: =IF(M4=San Mateo,"1",IF(M4=San Jose,"2")) which doesn't work, but this does =IF(M4=SanMateo,"1",IF(M4=SanJose,"2"))
Because other cells are dependent on M4 reading San Mateo vs SanMateo, I need a workaround.
Any ideas?
Thanks in advance