compare two columns

[aksusa]

Hi-


My Spread sheet has 4 worksheets:

Sheet-1:

Serverlist [ Col A ]

Serv1

Serv2

Serv3

Serv4


Sheet-2: [ Col A ]

Pre-check-Failed

Serv1


Sheet-3: [ Col A]

Outofscope

Serv3


Sheet-4 [ Col A]

DeploymnetStatus

Serv4


I need to compare all the 4 work sheets and need output in Sheet-1 [ Col B ]


Status


Serverlist [ ColA ] Status [ Col B ]

Serv1 Pre-Check-Failed

Serv2 Pending

Serv3 Out Of Scope

Serv4 Completed


I tried with vlookup and isna without luck. Can you guys help me with this. Great if someone suggest a macro . Planning to setup a button called compare and whenever the button is selected it will display the results


Thanks a LOT in advance

 

[Hui]

Akusa

try this in B2:

=IFERROR(IF(MATCH(A2,Sheet2!A:A,0),"Pre Check Failed"),"")& IFERROR(IF(MATCH(A2,Sheet3!A:A,0),"Out of Scope"),"")&IFERROR(IF(MATCH(A2,Sheet4!A:A,0),"Deployment Status Ok"),"")

Copy down to suit

 

[aksusa]

It works!!


Thanks a LOT.