Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need Vlookup to work with formula in reference cell
The following formula does not do the lookup: VLOOKUP(T7,Dues!$A$3:Dues!$G$154,2,FALSE) When T7 cell contains =(B9-S9) When I put the total that T7 equals in T7, it works. Any ideas how to make it work with the formula? thanks mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=393139 |
#2
|
|||
|
|||
My guess is that T7 is not what you think it is. If you see 9, it could be
9.0000000001. You could build that kind of rounding into your formula: =VLOOKUP(ROUND(T7,8),Dues!$A$3:$G$154,2,FALSE) mikeburg wrote: The following formula does not do the lookup: VLOOKUP(T7,Dues!$A$3:Dues!$G$154,2,FALSE) When T7 cell contains =(B9-S9) When I put the total that T7 equals in T7, it works. Any ideas how to make it work with the formula? thanks mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=393139 -- Dave Peterson |
#3
|
|||
|
|||
Mikeburg,
You've got it doing an exact match. Is there any chance that the formula is returning a number slightly different than the one you're typing in (with some extra decimal places or something)? Eric "mikeburg" wrote: The following formula does not do the lookup: VLOOKUP(T7,Dues!$A$3:Dues!$G$154,2,FALSE) When T7 cell contains =(B9-S9) When I put the total that T7 equals in T7, it works. Any ideas how to make it work with the formula? thanks mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=393139 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vary variables in a formula via reference to another cell | Excel Discussion (Misc queries) | |||
Using Vlookup in formula arrays | Excel Worksheet Functions | |||
My formula does not work! | Excel Worksheet Functions | |||
incrementing formula reference by 7 | Excel Discussion (Misc queries) | |||
formula won't work | Excel Worksheet Functions |