Excel IF/Reference another table

[DN89]

I need a formula where:

Row 1 is People attending an event, so there can be multiple columns of 0's. Example Scenario 1: Row 1, Column B = 0, Column C = 0, Column D = 0, Column E = 2, Column F = 4 etc.....

Row 2 is only activated when there is more than one person in Row 1. Yes I know the if function for this.

Now, the tricky part. For row 2 I need to reference a preset table of values on row 3. So:

If Row 1, Column B = 0, then 0, if not Reference table on Row 3, Column B which value is 2.

Since ROW 2 Column B = 0, because there is no value in Row 1 Column B, I now need Row 2 Column C's formula to reference ROW 3 Column B's preset value. and so on.

Column C, Row 1 is also zero, so onto Column D, also zero, so now:

Column E = 2, we finally have a value. I need this formula now to reference ROW 3, Column B and return the value.


Column: A B C D E F
Row 1: 0 0 0 2 4 (INPUTS)
Row 2: FORMULA (IF ROW 1 > 0, ROW 3 Column B value, IF NOT 0)
Row 3: 2 2 2 2 2 (INPUTS)