Search/lookup

  • Thread starter Thread starter tracyt620
  • Start date Start date
T

tracyt620

Hi there

I would appreciate your help with this, I have two worksheets

1 = list of pc numbers and user name (this will be where my results
will show)
2 = list of pc numbers and operating system

I want to perform a search so that I can go through all pc numbers on
sheet 1 and then search sheet 2 so that I can confirm that the pc
number is on both lists

Help with this would be great - many thanks


Tracy
 
Hi Tracy
in sheet 1 enter the following adjacent to your data (assumption column
A stores the pc number)
=IF(ISNA(VLOOKUP(A1,'Sheet2'!$A$1:$A$999,1,0)),"missing on sheet
2","found on sheet 2")
copy down
you can do the same vice versa on sheet 2

HTH
Frank
 
Back
Top