I am trying to create a formula that will grab from a table. The first column is number of people, and the first row is a percentage and the intersection is an \$ amount. So I have a cell with the number of people, and a cell with a percentage, how do I get the \$ amount to populate?

2. If you table is in range B1: D5 (B1: D1 are the percentages, row 2 values for 1 person, row 3 values for 2 people etc) and H4 has the cell with the percentage and H5 yhr cell with the number of people, a formula like this should work:
=HLOOKUP(H4,\$B\$1:\$D\$5,H5+1)

Steve

3. Blaze,

In the following table, the formula in cell C12 =VLOOKUP(A12,\$B\$3:\$L\$8,MATCH(B12,\$B\$2:\$L\$2,0)) will take the values of the number of people (A12) and the percentage (B12) and find the dollar amount.

HTH,
Maud

Vlookup3.png

4. A second formula that works equally as well:

in C12 place the formula =INDEX(\$C\$3:\$L\$8,MATCH(A12,\$B\$3:\$B\$8,0),MATCH(B12, \$C\$2:\$L\$2,0))

Index1.png

BTW, you can copy down on both formulas due to the absolute referencing in the ranges.

5. Thank You!!!! You just made my life a thousand times easier.

#### Posting Permissions

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