Vlookup nest

[travislynk]

Here is my deal:

I understand how VLOOKUP works, however the cell from which my VLOOKUP formula is drawing the answer (the 2nd column of the table), contains a formula.

OK, so the VLOOKUP brings in the correct formula to the cell designated and everything is fine.

However, the formula brought in has a cell in it that needs to change with the row where the VLOOKUP is. As of now, the formula has say R2 in the formula, but the formula will always draw R2 regardless. I need it to draw many different R values dependent on the cell.

This cell is already "relative", but is there a way to make it change with the row on the main sheet? Or will I have to do a super IF(IF(IF(IF(IF(IF....

THANKS.

 

[sweater_vests_rock]

hi travis.

not exactly tracking...it would help if you posted your sheet via Excel Jeanie or even showed your specific formula.

that said, the ROW() function comes to mind based on your description.

cheers. ben.

 

[travislynk]

Here is the VLOOKUP
=VLOOKUP(T2,Sheet2!B3:C22,2,FALSE)

where the the values in the C column are formulas....

here is an example of the formula in C3...

=5+(0.1*R2)+2.18

ok so I need that R2 to change to whatever row the coresponding VLOOKUP formula is....

Let me know if you need more information....

Thanks.

 

[travislynk]

More details:
<table x:str="" style="border-collapse: collapse; width: 316pt;" border="0" cellpadding="0" cellspacing="0" width="421"><col style="width: 59pt;" width="78"><col> <tbody><tr><td class="xl25" style="height: 12.75pt; width: 59pt;" height="17" width="78">RET EXT
</td> <td class="xl25" style="width: 112pt;" width="149">REASON
</td> <td class="xl25" style="width: 89pt;" width="119">GOODWILL DATE
</td> <td class="xl24" style="width: 56pt;" width="75">ADJ COST
</td> </tr></tbody><col style="width: 112pt;" width="149"><col style="width: 89pt;" width="119"><col style="width: 56pt;" width="75"><tr style="height: 12.75pt;" height="17"></tr></table><table x:str="" style="border-collapse: collapse; width: 420px; height: 25px;" border="0" cellpadding="0" cellspacing="0"></table> <table x:str="" style="border-collapse: collapse; width: 316pt;" border="0" cellpadding="0" cellspacing="0" width="421"><col style="width: 59pt;" width="78"> <col style="width: 112pt;" width="149"> <col style="width: 89pt;" width="119"> <col style="width: 56pt;" width="75"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 59pt;" x:num="0" align="right" height="17" width="78">$0.00
</td> <td class="xl23" style="width: 112pt;" width="149">GWP</td> <td class="xl25" style="width: 89pt;" x:num="39449" align="right" width="119">1/2/2008</td> <td style="width: 56pt;" width="75">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="29.99" align="right" height="17">$29.99 </td> <td class="xl23">MISC_TEAM_ISSUES</td> <td class="xl25" x:num="39449" align="right">1/2/2008</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="29.99" align="right" height="17">$29.99 </td> <td class="xl23">MP.PM</td> <td class="xl25" x:num="39449" align="right">1/2/2008</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="49.98" align="right" height="17">$49.98 </td> <td class="xl23">MP.UPS</td> <td class="xl25" x:num="39449" align="right">1/2/2008</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="162.99" align="right" height="17">$162.99 </td> <td class="xl23">MP.UPS</td> <td class="xl25" x:num="39449" align="right">1/2/2008</td> <td>
</td> </tr> </tbody></table>

There is a fourth column with an Adjusted Value, which applies a formula to column A. However the VLOOKUP to get that formula does not change with column A, giving only on correct answer, even if there are 100's of GWP...

 

[sweater_vests_rock]

Here is the VLOOKUP
=VLOOKUP(T2,Sheet2!B3:C22,2,FALSE)

where the the values in the C column are formulas....

here is an example of the formula in C3...

=5+(0.1*R2)+2.18

ok so I need that R2 to change to whatever row the coresponding VLOOKUP formula is....

can you lay out one example all the way?

in what cell is this formula:
=VLOOKUP(T2,Sheet2!B3:C22,2,FALSE)

what value does the formula return?
=VLOOKUP(T2,Sheet2!B3:C22,2,FALSE) = ?

i see that the VLOOKUP is returning a value from column C...is the issue with the VLOOKUP or the formula in column C? Are you trying to get the VLOOKUP to return a cell address instead of a value?

ben.