Adding CountIf Statement within If/ElseIf Statement

Hi Everyone,

Below is the code I'm looking to add to. I'm not really sure if a CountIf is what I'm looking for but I think it should work. In addition to the criteria shown below, I'd also like to add something that says "if the left 4 characters in (Cells(i, "A").Value) show up in Sheet1!J:J, then Cells(i, "D").Formula =... if they show up in Sheet1!K:K, then Cells(i, "D").Formula =...

Also, if anyone knows a good way to consolidate all of this, that would be great!

Please Login or Register  to view this content.

Let me know if you have any questions.

Thanks in advance!