Arvi:
Your suggestion to place the formula in SS2:Col 3 worked like a charm
except that when I drag the formula down the row, the cells
automatically get written with the current value in Col B.

The matching value from SS1Col B is written ONLY if I do a search in
that spreadsheet to look for SS2ColA value - defeating the whole
purpose!

Please help!
Thanks, Jay