Forum Discussion
#N/A is showing for 2 of my cells
Hello, I have an issue. I put through the formula (=IF(is_empty, "", INDEX($J:$J, MATCH(row_id,$X:$X,0) which is meant to bring data over from data input in the other cells (its meant to mirror the...
Hello,
Thank you for your response here's the screenshot that includes the formula I used.
Please also include what "row_id" refers to. This seems to be a named range, so you can find it by going to the Formulas tab of the ribbon, and click Name Manager.
A basic question, do you expect column J and column Y to be the same? If so, then you can use the simpler formula I suggested, rather than using the INDEX and MATCH formula.
A basic question, do you expect column J and column Y to be the same? If so, then you can use the simpler formula I suggested, rather than using the INDEX and MATCH formula.