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...
chay12 Your screen shot doesn't include the column headers, so I'm assuming that column J is the Item column in your table. If you just want to show the values from column J in the same order as they appear in J, then you can just use a formula like =J:J in the first cell of the range.
If that doesn't help, then please provide more details. Include the row and column headers in your screen shot. Where is the value that represents "row_id" in your formula?