Seeking help wrote:
THat right JLatham!!

A shorter version of example is like that

Sheet 1 might contain

NUMBERS ANS REGION
12345678 yes Asia
12345679 no Europe

Sheet 2 contain
NUMBERS PETS
12345678 dog
12345679 cat

So i got to displayed a result like this in my results sheet

NUMBERS ANS REGION PETS
12345678 yes Asia dog
12345679 no Europe
cat


--
Seeking help
------------------------------------------------------------------------
Seeking help's Profile: http://www.excelforum.com/member.php...o&userid=35658
View this thread: http://www.excelforum.com/showthread...hreadid=554398

will there be any common columns in both the sheets....?