|I'm not sure what you mean by "...place the value (of the Jan spreadsheet) into this cell." |
What value from the Jan spreadsheet?
In any case, maybe this will help...
I'll let you worry about file names and sheet names, and just offer the syntax for a possible solution.
Let's say I have this data:
A B C D
1 Part # 1 Plant # 1 Batch # 1 myValue
2 Part # 1 Plant # 1 Batch # 1
I only want to return "myValue" if the 3 values in Row 1 match all three values in Row 2. I think that's similar to what you want. Correct me if I'm wrong.
I would use this formula:
I split the formula into multiple lines to make it easier to read.
What it does is concatenate the results of the first three VLOOKUPs and compare that string to the concatenated results of the second three VLOOKUPs. If the string matches, then the last VLOOKUP returns the value I want. If not, I get nothing.