cell reference formula

Problem: My formula to lookup (using INDEX / MATCH) to pull in date values from one workbook to another appears to be working correctly, but some dates just pull in and convert to zero and I'm not sure why? What I'm trying to do: Is save time rather than copy manually all these over. The...

Hi! I thought I had this - turns out I am rubbish. I basically want to return a value in N3, if F3 (text data input) contains a value in N2 (header), otherwise return 0 I currently have : =COUNTIF($F3,"*"&N$2&"*") which works great to return a numerical value, but i want to later get a string...

I have a worksheet that is making cell references to a few HTML files. In most cases I will have all of the HTML files in a designated folder, but sometimes I may be missing an HTML file. In these cases I would want the cells in my worksheet o not give me the values when the HTML file was...

Hi all, I have a large formula which currently looks into another workbook, part of which is as follows: [Project_Record_List_05.02.2016.xlsx]Customer Handling'!$B$15), the 'Customer Handling' is of course the title of the tab the formula is referencing in to but is also written in cell C2 in...

I have a table that can be sorted with formulas that reference rows above/below a formula. As I sort the table, using absolute references or not, I cannot get the formulas to stay with the correct row as it is sorted. I also have formulas in the row that refer to other columns of that row so the...

Hello I have a table with 1000+ rows. One column is the Item Name. Each Item Name is unique, but will appear in 8 to 15 rows contiguous of data (before going to the next item name), the number of rows in each dataset can vary. I need to apply a formula (LINEST, etc) to that only references...