Lookup Value based on a formula

  • Thread starter Thread starter Cogeco news
  • Start date Start date
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
 
Unless you post the formula, we'll have to just guess at solutions.

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

XL2002, WinXP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup function to cell containing multiple values 3
Conditional formatting based on formula cell 6
Help needed 0
Doing a VLOOKUP (probably using the INDEX and MATCH function), withboth vertical and horizontal valu 2
Excel VBA 1
lookup and return column number 2
Counting Numbers 26
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5

Back
Top