SUMIF with multiple sum ranges

[aw12g10]

Hi All,

I've been looking through the old posts to try and find a similar situation, but no luck.

Basically, I have quite a simple set up.

I have 4 columns with a value in each. In the 5th column, I want the value of one of the columns to be entered, depending on the value of a 6th column.

For example, cells A1,A2,A3,A4 currently read 10,20,30 and 40 respectively. I would like one of those values to be entered into cell A5 depending on the value of cell A6. The value of A6 will be the title of one of the columns.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]In/Rep[/TD]
[TD]In/New[/TD]
[TD]Out/Rep[/TD]
[TD]Out/New[/TD]
[TD]Value[/TD]
[TD]Customer Description[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]20[/TD]
[TD]30[/TD]
[TD]40[/TD]
[TD][/TD]
[TD]Out/New[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]43[/TD]
[TD]35[/TD]
[TD]12[/TD]
[TD][/TD]
[TD]In/Rep[/TD]
[/TR]
</tbody>[/TABLE]

The table shown pretty much sums up the situation. What formula can I put in the 'value' column that will pull through one of the values depending on the customer description?

Any help would be HUGELY appreciated!

Thanks!

Alex

 

[Jonmo1]

For example, cells A1,A2,A3,A4 currently read 10,20,30 and 40 respectively.

I think you have that transposed....
it would be A1 = 10 B1 = 20 C1 = 30 and D1 = 40

Anyway..

Try this in F2 and filled down.

=INDEX(A2:D2,MATCH(E2,A$1:D$1,0)