Hi

Post your formula from some cell here - p.e. the one working, and the nex
one (not working). Probably your range references are wrong (relative vs.
absolute reference)


Arvi Laanemets


"Jay" wrote in message
oups.com...
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