Comapre two cells and display the results accordingly

[Karthikeyan Devan]

Hi All,

I need a VBA code where it check the criterias and display the result.

Suppose if A1 states "Hi" and B2 states "Hello" in cell C2 automatically display the result stating "Don't assign".

iF A2 states "Hello" and B2 states "Hey" then in cell C2 automatically display "Please assign".

To be more clear, A2 and B2 has a filter option where users choose from dropdown. According to the criteria, it has to display the result in C2, wherein C2 is also have a filter option where it has two options to display. One is Please assign and Don't assign.

Please assist me on this. Also, whatever it displays in C2 has to come has a Msg box as well which make people more alert.

Thank you for looking into this.

 

[poolhall]

Sub test()

If Sheet1.Range("A1").Value = "Hi" And Sheet1.Range("B2").Value = "Hello" Then
     Sheet1.Range("C2").Value = "Don't assign"
ElseIf Sheet1.Range("A2").Value = "Hello" And Sheet1.Range("B2").Value = "Hey" Then
     Sheet1.Range("C2").Value = "Please assign"
End If

End Sub

Replace Sheet1 with a code name for your worksheet, if needed.

 

[Scott Huish]

To be more clear, A2 and B2 has a filter option where users choose from dropdown. According to the criteria, it has to display the result in C2, wherein C2 is also have a filter option where it has two options to display. One is Please assign and Don't assign.

So how does A1 fit into this?

Suppose if A1 states "Hi" and B2 states "Hello"

 

[Karthikeyan Devan]

Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Thank you for getting back on this. Sorry for the confusion first of all. There are many criteria’s like this. Only if it is two we can use the Else if statement but I have many.<o></o>
<o> </o>
Examples are listed down. I believe we need to use nested if but I am not aware of that. Please advice…<o></o>
<o> </o>
If A2 states "Hi" and B2 states "Hello" in cell C2 automatically display the result stating "Don't assign".<o></o>
<o> </o>
if A2 states "Hey" and B2 states "Hi" in cell C2 automatically display the result stating "Please assign".<o></o>
<o> </o>
if A2 states "Rose" and B2 states "Fruit" in cell C2 automatically display the result stating "think before assigning".<o></o>
<o> </o>
if A2 states "Yes" and B2 states "No" in cell C2 automatically display the result stating "ignore".<o></o>
<o> </o>
Please advice and it would be great help!!!