If cell equals text from a range of cells on another sheet then enter value to the right

[rdoulaghsingh]

Good evening. I'm looking for a formula that will read the input from a dropdown list and if the text selected from the dropdown list equals one of the words from a range of cells on another sheet, then input the cell value of the cell immediately to the right of the text.

So basically, If cell A1 equals 'C' then read from 'sheet1' cell range A1-A26 and when C is found in the range take the value to the cell to the right (in this case 'B3) and make that the cell value with the formula.

Is this possible?

Thanks!

 

[Momentman]

If i understood correctly, then maybe a VLOOKUP would work for you

Book1
	A	B
1	C	15
Current

Cell Formulas
Range	Formula
B1	B1	=IFERROR(VLOOKUP(A1,Sheet1!$A$1:$B$7,2,0),"")

Cells with Data Validation
Cell	Allow	Criteria
A1	List	A,B,C

Book1
	A	B
1	X	21
2	D	13
3	C	15
4	B	16
5	A	17
6	G	18
7	E	19
Sheet1

 

[rdoulaghsingh]

The VLOOKUP did work! I had to tinker with it a bit, but it did the job. Thanks for the feedback @Momentman!