Interesting Question!

[aksusa]

Hi


My SpreadSheet Has 2 Sheets:


Sheet-1

Server-Name [Col-A]

Serv1

Serv2

Serv3

Serv2

Serv4


Sheet-2

Server-Name [Col-A] Wave [Col-B]

Serv1 P1:W1

Serv3 P1:W1

Serv4 P2:W1


I need the output in Sheet-1 in Col-B

Server-Name [Col-A] Phase [Col-B]

Serv1 P1:W1

Serv2

Serv3 P1:W1

Serv2

Serv4 P2:W1


The requirement is if we change the Sheet-2: wave column it need to automatically change in Sheet-1 under the Phase [Col-B] column


Thanks

 

[Luke M]

=IF(COUNTIF(Sheet-2!A:A,A2)=0,"",VLOOKUP(A2,Sheet-2!A:B,2,FALSE))

 

[aksusa]

It works.. Thanks for the help