I am comparing the values from column `A` to the values in Column B and expecting an output in Column `C`. Column `A` contains IDs. Each ID can have a Cloud or Not Cloud component. An app that is all cloud should have the output of the cloud. An app that is all not cloud should have the output of the cloud. An App with cloud and not cloud components is a hybrid

I have tried a basic excel formula comparing the range of the values in column A to the values in column B but there must be an easier way in VBA. I am new to coding but I do not believe it needs to be as complex as storing the values in an Array.

```
Sub CompareCells()
    If Range("AA:AA").value = Range("AA:AA").value Then
       'Not sure what to do here to evaluate after making sure the range is true
    Else
        'Not sure where to go next
    End If
End Sub

```

Example picture attached. The output should give the value of Not cloud, Hybrid, or Cloud depending on the disposition values of each application[![enter image description here](https://i.stack.imgur.com/K6Hgo.png)](https://i.stack.imgur.com/K6Hgo.png)