Newbie IF Help

[Jeff]

Hello everyone.

I have one spreadsheet which contains a list of drawing
numbers (e.g. 55891-110). I have another worksheet with
a list of drawings from the engineers which I have to
compare and pull out which ones my company has not yet
received. I tried putting the two columns side by side,
but ran into a situation were sveral drawings are missing
from the either my list or theirs and things got ugly
fast. Is there a way to seach one column and say yes it
matches a number in this column? Any guidance is much
appreciated.

Jeff

 

[Govind]

The best option is to make a pivot.

Use 2 columns A and B. Name column A as the drawings & column B as
source.Paste your list of drawings in column A. In column B against
these cells paste the source as "Your List" or something.Paste the
drawings from engineeers in the cells below your list of drawings in
Column A.Against these cells input "Engineers list" in Column B
correspondingly.

Then make a pivot with Drawings as row & Source as column and count of
drawings as data item. Compare the data

Regards

Govind.