Hi
I'm trying to pull back a reference number and a date. They could be on one of 2 sheets. I originally used 2 Index Matches but used the &" "& to separate them and it wasn't working with the date, I couldn't get it into the date format. Someone suggested putting it into a nested IF formula. I've put one of the index matches below that I need it to do but I'm not sure how to put that into a nested IF. The date is similar but with different columns.
IFERROR(INDEX(MKZ!D:D,MATCH('Sheet1'!H6,MKZ!N:N,0))
IFERROR(INDEX(SGC!D:D,MATCH('Sheet1'!H6,SGC!N:N,0))
I'd really appreciate any help
Thanks
I'm trying to pull back a reference number and a date. They could be on one of 2 sheets. I originally used 2 Index Matches but used the &" "& to separate them and it wasn't working with the date, I couldn't get it into the date format. Someone suggested putting it into a nested IF formula. I've put one of the index matches below that I need it to do but I'm not sure how to put that into a nested IF. The date is similar but with different columns.
IFERROR(INDEX(MKZ!D:D,MATCH('Sheet1'!H6,MKZ!N:N,0))
IFERROR(INDEX(SGC!D:D,MATCH('Sheet1'!H6,SGC!N:N,0))
I'd really appreciate any help
Thanks