=IF(G2=H2,"Match","Review") Need to modify to compensate for empy cells

[Aeroice]

Example.xlsHello,

So far I have this formula: =IF(G2=H2,"Match","Review") which is located in column I.

Whether or not there are values in G and H, it will say Match or Review. In my excel sheet I have data on every other row. The formula needs to be modified so that if there is no numerical data in column G and H, then neither match nor review will map in.

I've attached an example of my worksheet. In row 2, in columns G and H they contain no numerical value and "Match" still appears.


Thanks,

Rick

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[djapigo]

Try this...

=IF(OR(G2="",H2=""),"",IF(G2=H2,"Match","Review"))

[Aeroice]

That was exactly what i was looking for. Thank you very much.