Thread: IF Function

Hi All

I need to use a function (possibly IF) to look at 2 cells and return a value defined in another table

I've attached my file to make the explanation make more sense

I need the G cells to show IF phase = P1 and the cost is S then display £50 in G2 or if the cost is M then G2 needs to display £15

If any further explanation is required then please let me know

Thanks again everyone

Dan

Sorry i missed out a key point there

Basically I want to be able to input P1 or P2 in cell A5 then input either S, H, M, L into A6 and then return the corresponding price under those referenced fields for example P1 and M = £15 whereas
P2 and S would be £57

Hope this makes more sense

Try this combination of INDEX and MATCH formulas where B1:F3 is your table source and B6 and C6 are lookup entry cells.
=INDEX(B1:F3,MATCH(B6,B1:B3,0),MATCH(C6,B1:F1,0))
I attached the example as well.

Thank you so much temple1

That has solved my problem perfectly

Dan