Compare/Match two columns

[heartstealer]

It will be a great help if someone could guide me to do the following:

1. compare the Server Name and Serial Number values in Sheet 1 to the same in Sheet 2 and viceversa.
2. If values match populate the Machine Class column of the Sheet 1 with the Machine Class value from the Sheet 2 of the values found to be matching.


I have tried vlookup and a macro which actually helped me a bit to find the still no luck :'(

=VLOOKUP(A2,$B$2:$B$121,1,FALSE)

and

=VLOOKUP(B2,$A$2:$A$92,1,FALSE)

Where I had the Server names from Sheet 1 and Sheet 2 in columns A and B. However, this also didnt solve my problem.

I have Used this macro tryin to match:

Please Login or Register  to view this content.

However, wasn't successful :'(

Please do help...

[martindwilson]

you only have one match from sheet 1 to sheet 2 thats row 4
cddev 937h2fd9 thats using
=INDEX(Sheet2!B2:B1000,MATCH(A2&G2,INDEX(Sheet2!A2:A1000&Sheet2!D2:D1000,0),0))
in sheet1!I2 dragged down

[heartstealer]

Hi Martin,

Thanks for the quick formula which does the trick... However, does it compare the both Server names? Like Will it check if the Sheet 2 Server names are present in Sheet 1 also?

Thx in Advance

[martindwilson]

you dont say what you want to return so just to sheck if its present in sheet 1 .
in sheet 2 E2 put something like this
=ISNUMBER(MATCH(A2&D2,INDEX(Sheet1!$A$2:$A$1000&Sheet1!$G$2:$G$1000,0),0))
this will return TRUE when a match is found