Lookup Value based on a formula

C

Cogeco news

Hi all

I am looking up a value in a table that is based around other formulas.
When creating the Lookup the formula window shows the correct value.

When the formula is entered the result is DIV/0!.

Is there an easy way around it? or will I need the table based on hard
values?

Cheers
 
R

Ron Coderre

Unless you post the formula, we'll have to just guess at solutions.

***********
Regards,
Ron

XL2002, WinXP
 
Top