Search/lookup

[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

 

[Frank Kabel]

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

 

[tracyt620]

Frank thanks a lot for your help with this - worked a trea