Enter Text to return specific text

Question

Hey,&nbsp;I'm puzzled after a bit of research on how to achieve the following.&nbsp;I want my postcode to come up in an adjacent cell when I type "Home" into the previous cell. I also want the "Work" postcode to come up when I type "Work" in the same set of cells.&nbsp;Can someone tell me how to achieve this result please?&nbsp;Thanks.

sergeibaklan · Answer

BENNY17&nbsp;
You may create helper table which associates texts (Work, Home, etc) with postcodes and lookup (VLOOKUP, XLOOKUP, INDEX/MATCH) in main table.

benny17 · Answer

SergeiBaklanI'll attach a screenshot to see if it makes more sense, as I feel that my message may have been misunderstood.&nbsp;Thanks for your help.

sergeibaklan · Answer

BENNY17&nbsp;
That could be like this

Forum Discussion

Enter Text to return specific text

3 Replies

Resources