Change the number to the text assigned to it-CodePudding

I have sth like this:

It has 80k rows.

It has 2k rows.

I want to convert the numbers from column C to the text that I will get from column G (featuresval_id2=featuresval_id )

CodePudding user response：

you have to create a bran new column with this formula (for example to write into H2..): =index(G:G; match(C2;F:F;0))

CodePudding user response：

You can utilize match() and index() function in Excel.

match() will return the position of an item in an array. The item here is C2 in featuresval_id array. The array we want to search into is featuresval_id2. The 0 is saying that we want exact match.

MATCH(C2,featuresval_id2, 0)

After finding the relative position, we can use index() to get the value in another array - which you call name

=INDEX(name,MATCH(C2,featuresval_id2, 0))

Hope that helps.