Hi and welcome to MrExcel

Try this:

=IF(AND(E3="Cash",E4="Residencial",E5="Single"),VLOOKUP(C10,'RRP - RESIDENTIAL Cash Price'!A2:B18,2,0))

Thank you Dante

the following formula has worked

=IF(AND(E3="Cash",E4="Residential",E5="Single"),VLOOKUP(C10,'RRP - RESIDENTIAL Cash Price (Single Phase)'!A2:B58,2,FALSE))

now I have that working I also need to include the following formulas to existing formula as above.

if E3="Cash", E4="Residential", E5="Three",VLOOKUP(C10,'RRP - RESIDENTIAL Cash Price (Three Phase)'!A2:B58,2,FALSE))

if E3="Finance", E4="Residential", E5="Single",VLOOKUP(C10,'RRP - RESIDENTIAL Finance Price (Single Phase)'!A2:B58,2,FALSE))

if E3="Finance", E4="Residential", E5="Three",VLOOKUP(C10,' RRP - RESIDENTIAL Finance Price (Three Phase)'!A2:B58,2,FALSE))

if E3="Cash", E4="Commercial", E5="Three",VLOOKUP(C10,' RRP - COMMERCIAL Cash Price (Three Phase)'!A2:B58,2,FALSE))

if E3="Finance", E4="Commercial", E5="Three",VLOOKUP(C10,' RRP - COMMERCIAL Finance Price (Three Phase) '!A2:B58,2,FALSE))

If you could also help me here, that would be awesome.

Thanks!