lookup using two different sheets

[krazyhype19]

I am trying to use the formula in Sheet3 cell T4 for the summary. If I added an OR to IF statement, the answer is incorrect.

The formula should state like this:

if the result is not in Sheet1 then it should lookup the value in Sheet2. But, there are instance that the value is not only VL. It may be EL or SL or AWOL or VL 0.5 ... If this is not the value, then the result must be blank instead of the plotted time in Sheet2.

[krazyhype19]

Hi,

Anyone... please help...

[oeldere]

Maybe with an pivot table.

See the attached file.