S Sunny Sep 30, 2004 #1 Dave, I did check out the website, but did not find any suitable answers Thank you anyway. Sunn
D Dave Peterson Sep 30, 2004 #2 You could use a helper cell: =isnumber(match(b2,'a2'!b:b,0)) and drag down. You'll see Trues if there's a match. Falses if none. I'm not sure what you'll do next. But if you really don't care if there's a match, maybe =vlookup() will work for you. Debra Dalgleish has some nice notes for getting started with =vlookup() at: http://www.contextures.com/xlFunctions02.html
You could use a helper cell: =isnumber(match(b2,'a2'!b:b,0)) and drag down. You'll see Trues if there's a match. Falses if none. I'm not sure what you'll do next. But if you really don't care if there's a match, maybe =vlookup() will work for you. Debra Dalgleish has some nice notes for getting started with =vlookup() at: http://www.contextures.com/xlFunctions02.html
J jackgopher Joined Jun 11, 2008 Messages 4 Reaction score 0 Jun 11, 2008 #3 You can also find some helpful information regarding the vlookup function over here: vlookup excel
