need help with #N/A removal
I am running into some "#N/A" issues. It could be a formatting issue but I need some help.
I have a tab called raw. The "raw ordered" tab reorders the "raw" tab by pulling data from it using INDEX and MATCH function. It works nicely overall. But scroll over to columns AC and on, and it does not pull in the data from "raw" tab even though the data is there. It displays the "#N/A". That is my first issue. Can someone see why it is doing this? I checked for spaces in the IDs that the formula is pulling from and they are in identical format.
In the "tables" tab, it pulls from "raw ordered" tab. But the "S10 1:1000" displays "#N/A", even though in "raw ordered" tab, the "S10 1:1000" contains data. This is my second issue. How to fix this?
| Attachment | Size |
|---|---|
| example_2.xlsx | 64.19 KB |
Index
Hi,
It is returning #N/A! because the values in AD cannot be found in column C on the sheet "raw"
Try typing say "A3" in cell AD2 and you will see that the formula in AE2 will correctly return "8.04"
Hope this helps
Jon