With the last post that excelled software left for me to try.
I did what he asked and it just left a #NA in sheet 1, and in sheet 2 it left a #value.
I also thought that i placed the formula in the wrong column, so tried in all columns in sheet 2 with no prevail, nothing really at all shows up, in sheet 1.
Thanks for your interest.
Rog