If(And(countif)

[beginvbaanalyst]

Hi everyone,

I'm working on a spreadsheet where I have two tables. Table One is the previous month, Table Two is the new month. What I want to do is validate between the months for existing relationships using concatenate (already have setup in my table) to pull the newest balance value. I can do this without the formula with if(countif); now I want to add an additional statement where when it returns my value, i would like it to filter between two dates that i have as a reference cell throughout my entire return field (maybe 300 lines of data).

Can you even do this with If(and(countif)))?

 

[denzo36]

No one is ever going to solve your problem unless you share some data so we can see your issue

 

[beginvbaanalyst]

No one is ever going to solve your problem unless you share some data so we can see your issue

I was able to figure my question out. Thank you!