[Shigidim]

Dear all,

I have a weird outcome when using lookup function to match dates. I have a data set for October and a half of November. Both show the same - price of gold. However, due to some national holidays the dates are a bit different. What I want to do is to have a unified sheet with dates which exist in both data sets accompanied by the corresponding data themselves. Most of the work is done correctly. If there is no match in October then it gives you N/A which is fine because I can manually delete the mismatched later. However, by the end of November instead of giving me N/A it simply copies the previous cell!!! How cute is that? Could you kindly let me know what went wrong?

I have attached the sample for your convenience.

Many thanks!!!!!

[turbodante]

Welcome to the forum Shigidim.

Have you tried VLOOKUP for this task. See attached.

[turbodante]

Also, I notice that you have used the relative referencing in your formulae

See: http://www.cpearson.com/excel/relative.aspx

[Shigidim]

Turbodante, thank you very much indeed!

[turbodante]

Always welcome. If the problem is sorted, please mark the thread as solved - up top.