Formula for getting price from item listing when there is more than one price level column

Hi All,

I need help please with the attached workbook.

In cell D8 On the 'QUOTE' tab I want to be able to select the required price level from the drop down list and then have a formula in column H that will lookup the appropriate price from the relevant price level column on the 'ITEMS' tab based on the price level selected in cell D8.

Any advice greatly appreciated.

Thanks in advance.

Mel

Please find file attach, using array formula, means when ENTER you need to confirm press CTRL-SHIFT-ENTER button together, and copied down.

Thanks for all your replies. I will try these suggestions and let you know how I go.

Originally Posted by alansidman

In H12 =IF($A12>0,VLOOKUP($A12,ITEMS!$A$2:$L$388,9+MATCH($D$8,ITEMS!$J$1:$L$1,0),FALSE), " ") and copy down

I tried this solution and am happy to report that it is working as expected.

Many thanks Alan.