Need Vlookup to work with formula in reference cell

  • Thread starter Thread starter mikeburg
  • Start date Start date
M

mikeburg

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
 
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,

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
 
Back
Top