Is there a formula that inputs on nth row of column A by reading what's in column F and/or D on their congruent rows?

Question

I'm very new to excel programming. Currently I'm working on an excel worksheet and I need a formula that inputs on nth row of column A by reading what's in column F and/or D on their congruent rows. So far I have something like:

=IF(AND(D:ROW(n)=0,F:ROW(n)="x"),A:ROW(n)="e",IF(D:ROW(n)=0,"N","X"))
e.g.
  A B C D E F
1 e     0   x
2 N     0
3 X     2

you can find some informations here: http://stackoverflow.com/a/25291631/5384879 — Greaka, May 05 '17 at 12:53

score 1 · Accepted Answer · answered May 05 '17 at 13:03

1

Put this in A1:

=IF(D1 = 0,IF(F1="x","e","N"),"X")

And copy down.

The references are Relative, so as the formula is copy/dragged down they will change on their own.

answered May 05 '17 at 13:03

Scott Craner

148,073
10
49
81

My final version of this is =IF(ISBLANK($D1)," ",IF($D1 = 0,IF($F1="x","e","N"),"X")) – Aze May 06 '17 at 22:37

Is there a formula that inputs on nth row of column A by reading what's in column F and/or D on their congruent rows?

1 Answers1