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