Lookups
On 23 Jun, 16:52, RkB2008 wrote:
I have a list of 600 customer numbers that I am trying to compare to a list
of 6000 customer numbers to see if there are any matches.
I can not seem to create a lookup that calls out the location of the matches
in the list of 6000 from the list of 600.
--
RkB
To see if there are matches, you can use the COUNTIF function. If you
want the actual location of the match, you could use the MATCH
function, possibly in combination with INDEX. It really depends on
the exact structure of the lists, and what information needs to be
returned. Let me know if you want to know more about this, or can
give more detail.
|