Hi excelled Software,

I just got to your post, sorry. I am getting my MBA and working full time and just looked now. Ive had no time.

I really like the simplicity of the lookup formula you added by adding a formula to convert the date into a number date from 1900 followed by a symbol to differentiate it from the other symbols. It worked well for the data I am trying to use in my excel file. Thank you!

The other formula that uses Index and Match though; I don't understand the other formula and it is not working. The formula says #N/A, and does not come up with a value. However, I can see that it could work with the logic behind it. Let me know if that second formula can be rearranged. It may be useful because I wouldn't need to create a reference column. I think your attached files have both formulas. Thanks again.