I have both text in some cells and numbers in others across a row and I want to find a formula that will allow me to determine IF pre-determined criteria matches each other across the row, then return the result of the next cell in the row. For Example:

COLUMN A COLUMN B COLUMN C COLUMN D COLUMN E
Petro Penn Transport 4496 0.25

I would like a formula that will find for every time there is "Petro" in Column A, and "Penn" in Column B, and "Transport" in Column C, and "4496" in Column D give me the vaule of Column E.

Note: There are about 150 different choice for Column A. There are about 70 different choices for Column B. , about 10 different choices for Column C. , about 200 choices for Column D, and infinite choices for Column E.

Any and all help would be greatly appreciated.