Relate names with Id's
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.
Solution
Depending on what you are trying to do with it you could use VLOOKUP. I have created this sample spreadsheet where you can just introduce the name of the institution and get the ID based on the name, so that would create the relation between them.
The formula I used in this sample spreadsheet is:
= VLOOKUP(G3,B4:D8,3,FALSE)
Ref:
- I am new to VHDL programming, how can I debug these errors
- How do I check one column in R for a specific word and overwrite or return that word in another column?
- Python letter guess game
- is not null Vs != null (Unity C#)
- Right way to convert data.frame to a numeric matrix, when df also contains strings?
- print all the list elements with an even index number, error statement
- What exactly is the difference between reading a SqlDataReader with a while-loop vs. an if-statement?
- What is the difference between "if (hasrows()) { while (read()) }" and "while (read()) { if (hasrows()) }"?
- How can I use "*ngIf else"?
- I want Excel to interpret an operator as a caracter in a formula
- Using 'if let varName {...}' in Swift when varName is previously declared as a var
- PHP: Active record table joins
- How to do multiple if/else logic calculations and apply them to several columns in a dataframe?
- Checking for membership in an Erlang guard
- powershell testing a variable that hasnt being assign yet
- How to check if a string contains a substring in batch
- Compare ells A3 and A2, if equal, nothing else color row 3 cells A though F. Repeat with next row
- Dynamically updating and doing math on arrays in Excel
- Best practices for handling multiple nil/invalid checks without throwing an exception
- How to get the exit code when running `if ! command; then`?
- R If then do - how to create variables based on the condition
- How is Swift `if let` evaluated?
- Way to reduce else if statements when using string as condition
- if/else in a list comprehension
- How to build an if condition in shell to check whether curl succeeded?
- Navigate to another screen based on the dropdown item in Powerapps - Formula not working
- Dart null / false / empty checking: How to write this shorter?
- Writing a "Chessboard" function in Python that prints out requested length of binary
- Exclude multiple product IDs from WooCommerce coupons in an efficient way
- Godot 4. Why my if condition end without doing all her process