Hi,

I've attached a file to show my problem. I've created a dropdown list in A2 for the types of Boiler shown in column G.

What I'd like to do is have the price (reflected in column H) automatically come up in B2 dependent on the Boiler that is chosen.

Can anyone help ??

Thanks !!QUERY FILE.xlsx