MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help! Novice with array formulas here...

Posted by Liz J on February 05, 2002 10:02 AM

I've got two lists I'm working with. On one I have a list of people that took a survey of mine. On the other I have a master list of all names. All I want to do is simply put an indicator on the master list of the people that took my survey. Any suggestions?

Thanks much in advance!

Posted by Mark W. on February 05, 2002 10:06 AM

Use MATCH...

=MATCH(A2,$B$2:$B$100,0) where column A contains
your survey list and column B contains your
master list. Copy this formula down your
survey list. #N/A's mean no match... a number
is the nth entry in the master list.

Posted by Liz J. on February 05, 2002 10:38 AM

Re: Use MATCH...

Thank you very much Mark. It works like a charm!