I have a large worksheet of text data.

I need a formula or function to return the value in Column D if three (3) conditions are true in Columns A, B & C.

e.g. If A1="Name" and B1="Grade" and C1="HOR" then DesMoines

A B C D
1 Name Grade HOR DesMoines

Thanks for the advice in advance.

Brownie