PLEASE HELP!! NEED QUICK ANSWER AS HAVE TO HAND IN SPREADSHEET ASA

M

monsoonkhan

i have a list of names is a spreadsheet in cell a3-a20.

i have a nother spreadsheet and i want to create a formula in it that says
if any of the cells in the other spreadsheet range a3-a20 contain the name
smith for example, it will return the value yes, if not, no.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Missing default cell styles on some large existing spreadsheets 0
Is this possible? 1
Need Help Creating a Word Template using Excel 1
Hyperlink to cell and have it appear at top upper left hand corner 5
Sumproduct a column where 2 adj text columns contain same value 5
Need help modifying code 0
Help needed for inexperienced MS Excel 2003 user 2

Top