I feel like a dummy. I basically need a column that says - If column a2=0 then index and match column C, if that returns an error index and match column e, else index and match column a
Current formula that only works for If column a2=0 then index and match column C, else index and match column a.
=IF(A2=0,"",IFERROR(INDEX('Planned Look UP'!C:C,MATCH(C2,'Planned Look UP'!C:C,0)),IFERROR(INDEX('Planned Look UP'!A:A,MATCH(A2,'Planned Look UP'!A:A,0)),"n/a")))
I can't for the life of me get the column E step in there.