Forum Discussion
Enter Text to return specific text
Hey, I'm puzzled after a bit of research on how to achieve the following. I want my postcode to come up in an adjacent cell when I type "Home" into the previous cell. I also want the "Work" p...
You may create helper table which associates texts (Work, Home, etc) with postcodes and lookup (VLOOKUP, XLOOKUP, INDEX/MATCH) in main table.
SergeiBaklanI'll attach a screenshot to see if it makes more sense, as I feel that my message may have been misunderstood.
Thanks for your help.