Hello everyone,
i was wondering if there is a formula which could help me associating several words with one defined word, for ex., i have many items..water, milk, juice, and oil. when i write any word of these words...Excel writes "kilo" or "litter" & if i wrote (wood, stone, steel, or cement) Excel writes "ton".....etc
i used =if(or(.....)) but with many items it goes so slow while writing..is there any other way to solve it....thanks