Excel data search help

  • Thread starter Thread starter stew
  • Start date Start date
S

stew

I am asking for some help

I have a sheet which has full details of all the calls this month to
the helpdesk

I have a second sheet which has full details of all the systems on
contract and service pack

I need to find all the calls logged by contract customers and sp and
split them out for my boss

The only key that I can use (from what I can see) is the serial number
of the machine as it appears in both sheets and is unique

I am not sure how to do this can you help?

Thanks alot
 
Depending on how your data is laid out, you might be able to use
VLOOKUP for this - the sought item needs to be in the leftmost column
of the table for this to work. If this is not the case, then you can
use an INDEX/MATCH combination, in which case the column in which you
are looking for a match can be anywhere.

Post back some more details on how your data is arranged and exactly
what you want returned if you need any further assistance.

Hope this helps.

Pete
 
I have a number of columns of data I can move the serial number to the
left hand side that is not a problem. What I want returned is all the
instances of the serial numbers in list b that appear in list a and
all the data from the rows.

Thanks
 
Back
Top