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

1. 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.

Mel

2. Re: Formula for getting price from item listing when there is more than one price level co

replace formula in column H 12 with
Formula:
`Please Login or Register  to view this content.`

and fill down

the lookup section will return
1 for L0
2 for L4
3 for L7

thereby increase your vlookup column index number accordingly

3. Re: Formula for getting price from item listing when there is more than one price level co

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

4. Re: Formula for getting price from item listing when there is more than one price level co

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

5. Re: Formula for getting price from item listing when there is more than one price level co

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

6. Re: Formula for getting price from item listing when there is more than one price level co

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.

7. Re: Formula for getting price from item listing when there is more than one price level co

You are welcome. Thanks for the feedback.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1