Need if statement to answer one of 3 possibilities

[Carol Diedolf]

Good morning,
I am trying to figure out an if statement where the outcome can be one of three answers.

I am trying to see if incoming data matches what I already have in my database. The outcome should be as follows:

If the data matches, It should say match.
If the data is different, Excel should say Update.
If the incoming data is blank on a line, the outcome of the statement should say new data.

Attached is an example of how it should look.

Thank you in advance for your help.

Carol

[JohnTopley]

=IF($B2="","New Data",IF($A2=$B2,"Match","Update"))

[Carol Diedolf]

Thanks so much, John.

This is working perfectly for me!