Search if the value is in a column with values and add the value on the next column

[monchocolate]

Hello, I have a cell with a drop down in Spanish language coming from $TiposLocal.$A$1:$A$16
On the cell of the right I want to check the word added in that cell, compare it with the $TiposLocal.$A$1:$A$16 and add the word on the same row, but column B

How would that be? Thanks!

In page1, At column E people can choose between the options at page2 column A
The request is for adding at page1 column F the word at page2 column B next to the selected one.
For example, when people select in E2 Farmacia, F2 automatically adds Pharmacy.
ejemplo.xlsx (7.8 KB)

[LeroyG]

Excuse me you English-speaking guys.

Hola @monchocolat: No termino de entender (será flojera mental, eso explica por qué estoy escribiendo en castellano). ¿Podrías editar tu pregunta y subir un archivo de ejemplo? Indica allí dónde quisieras obtener el resultado y qué resultado. Gracias.

[monchocolate]

Gracias por la respuesta. Este es el ejemplo.

In page1, At column E people can choose between the options at page2 column A

The request is for adding at page1 column F the word at page2 column B next to the selected one.

For example, when people select in E2 Farmacia, F2 automatically adds Pharmacy.

ejemplo.xlsx (7.8 KB)

[LeroyG]

es:
=BUSCARV(E2;TiposLocal.$A$1:$B$16;2;0)

en:
=VLOOKUP(E2;TiposLocal.$A$1:$B$16;2;0)