Formula finding matching value

[montecristo]

Hi all,
Season greetings.

I'm trying to workout a formula that will compare columns A and columns B and depending on the outcome find the corresponding value in column E and enter that value in column D.

For example, if column A = column B then the result should be that column E's corresponding value in that row is correct and should be entered in column D - as per my image.

However, if column A does not equal column B, then I need the formula to take column B's value and match it to column A and then enter that matching column E's cell value into column D.

For example, A2 does not equal B2. B2 is equal to A5 and therefore cell value in column E of 4% should be entered in D2.

Hopefully this makes sense and not too complicated. ?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=INDEX($E$2:$E$12,MATCH(B2,$A$2:$A$12,0))

 

[montecristo]

Awesome dude, that worked a treat.

Much appreciated.

 

[Fluff]

Glad to help & thanks for the feedback.