The following is sample data set:

First Name Last Name Street City State Results Column
Jane Smith 123 Denver Write formula that would show what "category is missing". (i.e. State)
John 456 Salt Lake UT Write formula that would show what "category is missing". (i.e. Last Name)

I want to write a forumula that would identify "State" is missing in row 1 or "Last Name" is missing is row 2.

The empty spaces are blank and the data set has thousands of rows, so I would prefer not having to input text, etc. in the blank cells to make it work.

Thank you.