Guy Named EDd (& friends)
EDd is a figment of our imagination.
Pages
Home
How to see if a value is found in another range.
Email This
BlogThis!
Share to Twitter
Share to Facebook
Share to Pinterest
Use the formula below to check if a value in a cell is found in a range of cells (can be used across sheets or books):
=IF(MATCH([lookup value],[lookup range],0),"Found","Not Found")
No comments:
Post a Comment
Thanks for leaving a comment.
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Thanks for leaving a comment.