The Punters Lounge - The World's Best Betting Forum - View Single Post

GotaFancy? · 20-10-2006, 18:10

=IF(ISERROR(VLOOKUP(A2,Sheet2!$A$1:$A$1001,1,FALSE )),"","YES")

I think if you put this in cell B2 of Sheet 1 it should work (and copy it down to cell B301).

You can see my email address to the left (MSN contact - dont use MSN much, but do use the email addy)

20-10-2006, 18:10	#5 (permalink)
GotaFancy? God Punter Join Date: 18 Jun 2005 Posts: 33,996 Awards Showcase Total Awards: 4	Re: Microsoft Excel help =IF(ISERROR(VLOOKUP(A2,Sheet2!$A$1:$A$1001,1,FALSE )),"","YES") I think if you put this in cell B2 of Sheet 1 it should work (and copy it down to cell B301). You can see my email address to the left (MSN contact - dont use MSN much, but do use the email addy)