Such as A column value 1, b column values for the United States, what should b column input formula
A, B
1 China
2 the
1 China
1 China
2 the
Three British

CodePudding user response:

500
Using VBA

CodePudding user response:

Your problem description is not clear, but should be able to solve with condition judgment, such as A column value is 1, B column shows the United States; A is 2, B shows China; A are other values, B shows that Britain, can be implemented with the following formula:
=the IF (A1=1, "us", the IF (A1=2, "China", "British"))

CodePudding user response:

This simple, using A conditional statement is ok, the right upstairs, if A column of A total of only three values, so to write

CodePudding user response:

Just you two words, the IF function
Two or more, can use VLOOKUP query function, etc

CodePudding user response:

Build the following regions for vlookup function to search
1 the
2 China
Three British

In column b using vlookup function
For example;=VLOOKUP (M15, $R $9: $S $11, 2, FALSE)
$R $9: $S $11 for the above search area
M15 a column is a search object