When VLOOKUP can't find a value in a lookup table, it returns the #N/A error. You can use the IFNA function or IFERROR function to trap this error. However, when the result in a lookup table is an empty cell, no error is thrown, VLOOKUP simply returns a zero.
Hope this helps,
J Wick
INSERT INTO TableA
SELECT TableB.* FROM TableB LEFT JOIN TableA ON TableB.ID=TableA.ID
WHERE TableA.ID is null
As an example, check below steps
Often you might need to calculate the number of duplicates in your data without the first occurrence. You can count the number of duplicates excluding the first entry in the same way as the previous example. To count the duplicate examples from the last example without the first occurrence:
Select cell F2.
Assign the formula =COUNTIF($C$2:$C$8,E2)-1.
Press Enter to apply the formula.
This will help you,
J Walter
