Searching Excel for a value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If column A and column B both contain a list of names, what formula con I put
in C1 so the result indicates if B1 exists anywhere in column A?
 
=isnumber(match(b1,a:a,0))

is one.
If column A and column B both contain a list of names, what formula con I put
in C1 so the result indicates if B1 exists anywhere in column A?
Click to expand...
 
You must log in or register to reply here.

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

Find partial text and retrun value in corresponding column 3
Nameing a function 1
setting cell values based on a 3rd cell 4
Countifs with different restrictions 1
Concantenate which keeps bold of some parts. 5
SUMIF with criteria "<>" & "=" 4
Return the value from one range that does not exist in another 0
Need Help 4

Back
Top