Can someone please explain how to do this with different words:
I have two columns (A&B) and about 40 rows in excel. I want to put in different words, say - Paper in A1, Chair in A2, Glass in A3,and have values (say 25, 33, 47) show automatically in B1, B2, B3. [I know IF(A1="Paper",25,"") helps address this for row A1].
But, how can i pre-set the excel doc, for multiple words, such that when someone types - PAPER - in line A22, it automatically shows the value (25) in B22, or Glass in A29 with value (47) showing automatically in B29 . Can you kindly explain how to do that?