Im trying to get a value from 6 cells. Im entering the if function into B2.
cells C2, D2, E2, F2, G2 & H2 have either #N/A or the the answer Im looking
for but the answer is not always the same.

If C2 = #N/A then I want it to look in D2, if D2 = #N/A and so on until it
finds the cell that doesnt equal #N/A.

Please help, trying to work this out is doing my head in..........

Thanks,
Kirk