sv29: Once again, you have ignored the cross-posting etiquette, for which please read: http://www.excelguru.ca/content.php?184
Kindly provide all cross-post links.

Note also that, if you make a habit of not providing the links, you risk having your account here terminated.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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