Yeah, it's a thing of beauty!

For only 2,3,4 sheets I might opt for the nested IF.

Biff

"Dave Peterson" wrote in message
...
Oh my gawd,

=IF(SUMPRODUCT(COUNTIF(INDIRECT("'"&WSlist&"'!A:A" ),A1)),VLOOKUP(A1,INDIRECT("'"&INDEX(WSlist,MATCH( TRUE,COUNTIF(INDIRECT("'"&WSlist&"'!A:A"),A1)0,0) )&"'!A:B"),2,0),"")

It's alive!!!!!!!!!!

<vvbg