referances

Hello everyone, I have two tables named Movies and Users. I want to create let's say something like a matrix of Movies and Users table by adding and multiplying a row from Users with another row from Movies. The SUMPRODUCT is an elegant method doing the calculation. The problem is I have to...

I have a table of data and when I delete the 5th row the data is replaces from row 6 because it moved up. How can I make sure my referances stay the same instead of showing #REF ! Below is an example of two formulas I've tried...

Hi, So I had the formula <tbody> </tbody> =IF('12'!$D$34="","",(LOOKUP(2,1/ISTEXT('12'!$D$34:$D$76),('12'!$D$34:$D$76)))) before and it was working perfectly. Trouble is that I've changed the values that I used to put in the cells D34:D76. The values there now refer to another cell...

Hi There, I'm sure I must be over thinking what is a simple problem but the solution I came up with originally is a bit of a work around! Basically I need a formula for calling up the row in which the previous value in column A resides. The solutions should look like the those in column B...

Hello All, I really need your help- i am willing to find out a way in which reference file name for vlookup is from cell O6 from each worksheet. =IF($C6="","",IFERROR(VLOOKUP($C6,'C:\Users\XYZ\Desktop\[Indirect(!$O$6).xls]DataSheet'!$B$14:$AB$488,9,FALSE),0)) please help me really appreciate it

I'm sure this is a common question but I have yet to be able to solve it even with searching the forums. The goal is to pull a date from the sheet 'Tracker' see if the date has passed or if it occurs within the next month. If true it needs to print an 'X' in the appropriate cell on the sheet...