# If another cell contains value from range, then = another cell's value

#### SevenOut

##### Board Regular
A1:A10 May contain values found in range E1:E10.
Formula In Cell B2: If A2 contains a value from range E1:E10, then reference the value from A1.
I'm having difficulty figuring out a formula to accomplish this.

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

#### Yongle

##### Well-known Member
try this formula in B2
=IF(COUNTIF(\$E\$1:\$E\$10,A2),\$A\$1,"")

#### SevenOut

##### Board Regular
Got this to work by:
=IF(A2>"",\$A\$1,"")

In this case, I did not need to check of values matched any in range E1:E10, just that they held a value.

Replies
6
Views
81
Replies
10
Views
146
Replies
2
Views
49
Replies
13
Views
80
Replies
1
Views
130

1,126,939
Messages
5,621,720
Members
415,853
Latest member
Newlife72

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back