google sheets - Matching a value to an item taken from a dropdown list

Question

I've got a particular problem that I'm hoping someone can help me solve. I'm using Google Sheets to build a character sheet for a roleplaying game. As part of the sheet, players can choose equipment from a dropdown list. The items in this list, and their related data, have been imported into the sheet already using IMPORTRANGE from another sheet that acts as a global database.

In this example, the player can choose from a list of weapons. The data also includes the weapon's attack power. There are thus two columns here in the equipment sheet: one that contains a drop down list with the possible weapons the player can choose from, and one that should retrieve the chosen weapon's attack power. This data exists side by side in the sheet already, but I'm having trouble accessing it. How can I automatically populate the attack power cell with the correct value to match the chosen weapon from the dropdown list? This data already exists in the spreadsheet side by side in the correct order so it doesn't seem like it should be difficult, but I'm not really sure how to do it!

Thanks in advance!

question from:https://stackoverflow.com/questions/65921803/matching-a-value-to-an-item-taken-from-a-dropdown-list

Answer 1

try simple VLOOKUP:

=IFNA(VLOOKUP(N13, U:V, 2, 0))

and then you can multiply it with value you wish if needed