vendredi 27 février 2015

Abbriviate multiple Values on one sheet into one cell on another sheet?

I have Sheet 1(Year) and Sheet 2 (January). What I want to do is, if Cell H4-H7 on Sheet 2(January) contain any of 11 possible words e.x.(San Francisco, Napa, Novato, Stockton....) it will abbreviate the word to Cell B3 on Sheet 1(year) SO if "San Francisco would read SF". If nothing in those cells then it would remain blank.


Aucun commentaire:

Enregistrer un commentaire