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 item list) but it seems to only work for well until I get down to the cells 27 and 28. This file contains data that I extracted from my other Excel spreadsheets using formulas.
Could someone please assist me this.
Thank you.
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?
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.
