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?

enter image description here

enter image description here

  • 4
    List all possible words and associated values in a separate table and use VLOOKUP – cybernetic.nomad Apr 7 at 14:57
  • Welcome to SuperUser! Step 1 in asking a good question is researching on your own. In this case, I think the phrase you were missing was "lookup table" or, as cybernetic.nomad mentioned, the name of a helpful formula. I personally prefer XLOOKUP but it's only available for Office 365 so VLOOKUP is more universal. Try a web search with some of those key phrases and see how far you can get on your own. – Engineer Toast Apr 7 at 15:16

You could use VLOOKUP function and IF function.

Here is the formula in the sample.


Just change A4 to other cell like A5, A6 and so on.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.