Sorry, I didn't realize all forums are connected and cross-posting inst allowed without posting the links to the other forums, my mistake, ill make sure it doesn't happen again.

I have this same topic posted on the following sites/forums:
http://www.vbaexpress.com/forum/show...ookup-formulas

https://www.ozgrid.com/forum/forum/h...ula......topic has been closed

https://www.ozgrid.com/forum/forum/h...lookup-problem

That being said, i do no not have a solution to this problem yet, so any help would be greatly appreciated.

Thanks