I'm trying to relate some Ids with names as the image below:

Basically I would like to create a relation between the institutes and their corresponding Ids, at my first thought was doing something like =if(A2 = 81, "Institute example 1", ""), but I would like to know if there is a better way to do it.

CodePudding user response：

Depending on what you are trying to do with it you could use VLOOKUP. I have created this sample

Ref:

• VLOOKUP