Cells will not calculate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the replace feature to modify a rather long formula. I have to
modify it in each column, abour 30 cells per column.

Anyway I am replacing $D with $E = the replace feature works perfectly but
after the change the cell does not calculate and return the data... HELP. It
is far to tedious to make the chabge manually.

=IF(ISNA(MATCH("N12",Schedule!$D$49:$D$102,0)),"",INDEX(Schedule!$B$49:$B$102,MATCH("N12",Schedule!$D$49:$D$102,FALSE)))
 
Even with calculation set to manual, the cell should recalculate after
making a find and replace change. Your formula is set to return a
blank, "", if the MATCH portion of the formula fails. Does the value
of N12 exist in Schedule!E49:E102?
 

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

Formating not recognised in lookup formula 2
Index and match formulas 1
Cell not calculating after importing data 2
Mandatory cells only if another cell is filled 0
Search two columns in list for first and last name and return Id 4
Lookup part of a cell's contents and return value of entire cell 2
Calculation Speed (Index/Match vs Vlookup)? 6
Year-to-date based on current month 2

Back
Top