MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VLOOKUP....HELP!!!!


Posted by Sam S. on December 07, 2000 4:15 PM

I AM HAVING TROUBLE USING THIS FORMULA FOR WITH MY WORKBOOK. I AM SUPPOSED TO USE IT WHEN I HAVE A SALES SHEET AND DIRECT THE TOTAL SALES COLUMN TO A TABLE THAT HAS DIFFERENT DISCOUNTS FOR DIFFERENT TOTALS AND I CANT MAKE THE FUNCTION WORK. IF ANYBODY HAS ANY THING THAT THEY CAN GIVE ME OR POINT ME IN THE RIGHT DIRECTION I WOULD BE VERY GRATEFUL. THNX


Posted by GregA on December 07, 2000 10:22 PM

I assume that you are looking up a discount % based on the sales total. I also assume that your lookup table has two columns -- total sales amounts in the left hand column, and the corresponding discount in the right hand column. In that case, the formula you want in the Discount % cell would be:

=VLOOKUP(total sales,lookup table range,2)

For example, if your Total Sales is in B5, the lookup table is in the cells A12 to B16 (with A12 thru A16 having sales amounts, and B12 thru B16 the corresponding discount %s), then the formula would be:

=VLOOKUP(B5,A12:B16,2)

E-mail me if you want me to send you a sample Excel sheet with this.

Greg