Quote Originally Posted by robert111
if cell A2 on first sheet contains "b", does cell A2 on second sheet contain "b"?

In other words, does it read blank,b,c,d,blank OR b,c,d?
The second sheet data is also placed randomly. I mean there are no blanks only the subset entries are there in sheet 2 column A and i want rest of the entries in column B.