Have an excel sheet which contains items database in one sheet and an "invoice creator" on another.
Once part numbers and quantities are pasted from an external source, what the formula does is extracts information from different cells from the database and populates it in the invoice creator with various rules (IFs, VLOOKUP and copy paste and combine).
So from 320 items i pasted 99 are just not being found by the same formula and keep showing up as #N/A.
Have gone step by step in the HELP > HELP ON THIS ERROR (verified record exists in the databaase, same cell format, no spaces and extra signs and etc) and still 99 items fall under #N/A.
Have also tried doing it in a new separate tab.
Attached a part of the report - please see column C.