Need help with cell selection

[Jdhouse]

Total beginner here.
I cant seem to lookup a pricing page to return a price in another worksheet cell. I hope that makes sense.
I have tried to use lookup but I cant quite work it out. What I am trying to do is " if cell d2=(this) and cell e2 = (this ) then get a price from the pricing sheet that corresponds to the pricing matrix. I know this makes sense to me but can you understand what I am trying o do? this is hurting my head.
Thanks in advance for your input and guidence.

[kvsrinivasamurthy]

Pl see attached file with formula.

[Jdhouse]

Thank you For the solution. I was nowhere close to that answer. I will have to study it and see if I can under stand it now. Is this one of many way to do this or is this the best way to get the pricing?

[Kevin UK]

Hi Jdhouse

INDEX & MATCH is an option:

Please Login or Register  to view this content.

Is the price, the cost per foot! If so multiply by the length Cell F2:

Please Login or Register  to view this content.

[Jdhouse]

Thank you I will try this out tonight.
I really appreciate it.
Thanks again!