Thread
:
vlookup over 2 sheets?
View Single Post
#
10
Dave Peterson
Posts: n/a
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
Reply With Quote