Welcome Guest.


Excel enters different values in A1, and the corresponding characters are displayed in B1

Asked by: Amanda Walsh 11 views IT August 5, 2022

EXCEL input 1 in A1, output Zhao Yi in B1, A1 inputs 2 output Wang Er, and so on. Input different values in A1 will display the characters in B1

2 Answers

  1. +1Votes  

    = lookup (A1, {1,2,3,4}, {“Zhao Yi”, “Wang Er”, “Sun Wu”, “Malacca”})

    Push to add and add:

    = lookup (A1, {1,2,3,4, …}, {“Zhao Yi”, “Wang Er”, “Sun Wu”,”Malacca”, …})

    Answer: If there are many data, according to the method of the netizen’s [Tucao to vomiting], list the “corresponding table”, and use the search function lookup or vlookup.

    Frank Wright- August 5, 2022 |

  2. +2Votes  

    You have to have a corresponding table first, otherwise the computer cannot find the law you want

    David Morris- August 5, 2022 |