LOOKUP function using date as value.

[Joeg101]

I am creating a summary sheet that references values across several different workbooks. In the summary sheet Col "A" has a several dates in it and Col "C" returns the corresponding value. In example:

"A126" = 05/01/2010
"C126" = finds "05/01/2010" in another workbook called "specific 05-10". If it locates "05/01/2010" than it returns the value in Col "C" of that same row. If there is no "05/10/2010" than it returns "0".

The problem I am having is that Excel wants me to reformat the column containing the dates but the workbooks are downloaded daily by different people and I would the least amount of contact with the workbooks to prevent human error.

So I guess my question is how do I use the LOOKUP function without reformatting any cells.

Thank you in advance for your time and energy. I truly appreciate it!

Joe

[NBVC]

Post a workbook sample explaining the issue.

[Joeg101]

Attached are the files you requested. Please note that that file named "specific 05-10 TEST" is the target file.

Thanks again,
Joe

[NBVC]

So, I used this formula and got expected results...

=IF(ISNUMBER(MATCH(A2,'specific 05-10 TEST.xlsx'!$A$2:$A$23,0)),VLOOKUP(A2,'specific 05-10 TEST.xlsx'!$A$2:$C$23,3,0),0)

copied down

which was the code found in column C or 0 depending on whether the lookup value existed.

I am not sure what the problem is?

[Joeg101]

That works perfectly. Thank you so much!