Check 2 values in a row against 2 values on another worksheet

[trfoster]

I'm hoping someone can help me with a formula. I have a worksheet with a list of forecasted projects. On a seperate worksheet in the same workbook, I have a list of all of the current projects. Weekly, I delete the list of current projects and paste the updated list.

What I need is a formula that verifies 2 values on the current project list against the same values on my forecasted projects to see if any new project lines have been added. I've got a formula that currently uses a VLOOKUP to check out one value and that works fine. However, I want to actually check 2 values and I can't figure out how to make it work.

The formula I'm currently using is:

=IF($F3=(VLOOKUP($F3,Forecast!$H$2:$H$854,1)),"YES","NO")

Basically, I want to keep some form of this where F3 on my current project list checks against the Forecast worksheet for the same value (all values in column H have been sorted lowest to highest). However, because it is possible to have multiple lines with the same F3 value, I need to verify that all lines with the F3 value on the current project list are represented on the forecast tab so I'd like to additional check H3 on my current project list against J3 on my forecast tab and make sure that if it does find F3, it has all of the appropriate lines if data.

[deemo]

Not 100% sure what you want to do (upload an example perhaps?) - but would a fairly simple AND formula do the trick?

[trfoster]

Here is a sample file.

The data on the unbilled tab is deleted and replaced with current data each week. I want to make sure that when I add the new list of unbilled projects, that I have every line item represented already on the forecast tab.

As you can see in this sample file, currently, the verify column shows "Yes" for everything even though Line 2 is actually not listed.

I do believe the answer is a simple AND statement but I've tried and for some reason I just can't seem to make it work correctly.

[trfoster]

Anyone have any thoughts on a formula that will work for this?

[deemo]

Seems to me that you are doing a lookup on the order#, but this is actually not unique: you can have several projects per order?

[trfoster]

Deemo,

You are correct. I can have several "deliverables" per order number and I need to make sure all are captured. That is why I need to augment the VLOOKUP with some kind of AND statement that checks both the order number and part number to make sure all elements are included on the Forecast tab.