Checking dates against Store ID

[huc]

Hi all,

I wonder if someone can help with a formula please?

I have two seperate workbooks.

In sheet 1 of workbook 1, Column A is a store ID, and column B is the install date.

In sheet 1 of workbook 2, I have exactly the same set up, store ID in column A and install date in column B.

I need to be able to check in column C of workbook 2 that the installation dates match for the same store ID's.

I kind of want it to do a compare store ID in workbook 1 sheet 1 to store ID in workbook 2 sheet 1, and where they match compare the date in the adjacent columns and give me a "match" "no match" response.

Does that make any kind of sense to anyone LOL?

Thanks,
Chris

 

[huc]

Is it something I could perhaps do with vlookups?

 

[JazzSP8]

Hi

Sounds plausible to do

Try something like;

=IF(VLOOKUP(A2,[WorkBook1]Sheet1!A:B,2,FALSE)=B2,"Match","No Match")

That should work providing you amend the names / ranges to suit