IF formula help, replicating data based on variables

[justanotheru]

[TABLE="width: 500"]
<tbody>[TR]
[TD]1 a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]aa[/TD]
[TD]ad[/TD]
[TD]ag[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]ab[/TD]
[TD]ae[/TD]
[TD]ah[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]ac[/TD]
[TD]af[/TD]
[TD]ai[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]OPTIONS[/TD]
[TD]aa[/TD]
[TD]af[/TD]
[TD]ah[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]RESULT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I'm trying to make a formula that will help me copy data based on a set of variables.

Three options are listed in cells B3, B4 and B5. If the data in cell C8, D8, or E8 is the same as either B3, B4 or B5, I want the data to be copied into cell C12. So because cell B3 is the same as C8, cell C12 would display the text aa. Similarly, if any of C8, D8, or E8 matches C3, C4 or C5, the corresponding data will be copied into D12.
If there is no match, the cell would be blank

The rough formula I have for cell C12 is something like



=IF(B3 or B4 or B5 = C8), [C8 = C12], =IF (B3 or B4 or B5 = e8, [D8 = c12], =IF B3 or B4 or B5 = E8, [f=E8 = C12]




I'm sure this formula is extremely error-ridden, but I'd be super grateful if anyone could help me tidy it up.


Thanks in advance.

 

[Special-K99]

"Similarly, if any of C8, D8, or E8 matches C3, C4 or C5, the corresponding data will be copied into D12."

What happens if there's more than one match?
What should D12 show then?

 

[Special-K99]

Ignore this, my solution wont work for all of them.

 

[justanotheru]

"Similarly, if any of C8, D8, or E8 matches C3, C4 or C5, the corresponding data will be copied into D12."

What happens if there's more than one match?
What should D12 show then?

There will only ever be one match per row if that helps

 

[justanotheru]

There will only ever be one match per row if that helps

One match per colum, ie there can only be one possible value or blank for C12. D12 etc.