tropics123
Board Regular
- Joined
- May 11, 2016
- Messages
- 85
Hi guys, I ran into a roadblock and was hoping someone could shed some light. Row 1 is the header. There is currently lookup formulas in all cells starting on C2. My formula in G2 is basically looking if C2 is blank, then move on to pull in a value from C2 and if C2 is blank then move onto D2, and so on. However, the issue is, those cells even though they look like blank, there's a lookup formula in them so my formula doesn't work. Is there a formula that can do what I'm doing but ignore the lookup formula in those cells and still consider them as blank? And all cells return blank then put in value "N/A". Thank you in advance!
Here is my formula:
=IF(ISBLANK(C2),IF(ISBLANK(D2),IF(ISBLANK(E2),IF(ISBLANK(F2),"N/A",F2),E2),D2),C2
Here is my formula:
=IF(ISBLANK(C2),IF(ISBLANK(D2),IF(ISBLANK(E2),IF(ISBLANK(F2),"N/A",F2),E2),D2),C2
Column A | Column B | Column C | Column D | Column E | Column F | Column G |
NAME | ADDRESS | DATA 1 | DATA 2 | DATA 3 | DATA 4 | Final Answer |
=IF(ISBLANK(C5),IF(ISBLANK(D5),IF(ISBLANK(E5),IF(ISBLANK(F5),"N/A",F5),E5),D5),C5) | ||||||