I am creating a template to use when comparing a list of telephone numbers,
received on a monthly invoice, against an inventory list of telephone numbers
and want to generate a list of the numbers contained in the monthly invoice
that do not appear in the inventory. Each list is a column in Excel on the
same worksheet and in number format. I have tried using functions that
compare one cell reference (i.e. a cell containing a number from the monthly
invoice) against a range of numbers (i.e. the column of cells containing the
inventory list). The function I have used successfully only works when the
number being searched for is at the top of the range. If the number being
searched for is somewhere else in the range it is not recognized.