Building a Formula Using Field Blank or Not Blank

[meppwc]

Can someone please offer assistance?
I need a formula in cell C2 of worksheet "MAIN" that considers the following logic:
Using the value in G2 of "MAIN" worksheet, search column D of the "OBIEE TABLE" worksheet
If the value is found:
- Look at column P of "OBIEE TABLE", if the cell is blank, then, "T&M", if the value in column P is not blank, then, map the value in column T
If the value is not found, then "Not in OBIEE"

 

[Fluff]

Still having problems.

With which formula & what is the problem?

 

[meppwc]

Fluff
I just need a formula that addresses the following scenarios
SCENARIO 1
Search on the value in G2 of "MAIN" against "OBIEE TABLE" (column D)
The value from G2 was found, thus, we then go to the same row where the value was found (in my case that is D8638) "OBIEE TABLE" column P.
Cell P8638 is blank, thus, the value in G2 of "MAIN" ="T&M"
SCENARIO 2
Search on the value in G2 against "OBIEE TABLE" (column D)
The value from G2 was NOT found, thus, the value in G2 of "MAIN" = "NOT IN OBIEE"
SCENARIO 3
Search on the value in G2 against "OBIEE TABLE" (column D)
The value from G2 was found, thus, we then go to the same row where the value was found (in my case that is D8638) "OBIEE TABLE" column P
Cell P8638 is NOT blank, thus, we map the value in T8638 of "OBIEE TABLE" to G2 of "MAIN" (in this scenario G2 of "MAIN" = "8x5x4 GOLD"

 

[Fluff]

That is exactly what the formula I suggested should do. Therefore can you please answer my questions?

 

[meppwc]

I am so sorry. I neglected to increase the ranges in the formula on columns D, P and T from 1000. Once I did that it works perfectly and I am very grateful for your assistance.

 

[Fluff]

Glad it's working & thanks for the feedback.