Find a value of a cell in a column
I apologize in advance if even my search efforts have not found an answer to my question, believe me I've tried.
Ok, I am comparing two lists. There are no duplicates within each list.
What I am unable to figure out is....
How to see if the value of a cell is present in a column on the same work sheet.
I have been searching the net and this forum and I can't figure out how to ask the question or search for the answer any other way. One cell has a value of 10024 if this value isn't present in a column on the same worksheet I just need to know.
can someone please help me or point me in the right direction.
Much appreciated
Keith
Try something like
=ISNUMBER(MATCH(A1,B:B,0))
where A1 contains value to look for in column B
TRUE is returned if a match exists...
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Hi,
Try using vlookup
suppose the value to find is in cell A1 and the column to search is B , the enter the following in cell C1
=iferror( vlookup(A1 , B:B , 1, 0) , "Not Found")
Shijesh Kumar
http://shijesh.wordpress.com/
That really was easy. Thank you so much. I use excel for some listing that I do with customers and I've found that ASAPUtilities has been very helpful but I just couldn't come to grips with this little task and I appreciate the help. Thank you so much once again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks