How to find out numbers in two columns
Hi
I would like to know the formula to see if a number in column B exists in column A (see attached excel sheet).
Example: The nr. 2 row contains number of (A) 15001865, and (B) 15001865. So here the answer (I think you can type whatever answer you would like to?) would be something like "exist".Test.xlsx
you could use =vlookup(--b2,A:A,1,false) and if it returns an error it isn't in the list.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
if you want something a little more dynamic you could try this one instead.
=IF(IFERROR(VLOOKUP(--B2,A:A,1,FALSE),"")="","not in list",VLOOKUP(--B2,A:A,1,FALSE))
EDIT: BTW, put either of mine in cell C2 and copy down if that wasn't apparent.
Last edited by Sam Capricci; 06-18-2015 at 05:22 AM. Reason: clarity
With match.
The problem is you have textformat in column B.
I used a formula to translate the textformat in normal format (in column C).
After that a formula to see if the data match.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Kan you write this into the excel sheet please?
like this?
Thanks for answering. I didn't fully understand your formula, because in row 11, you say that "value dont exist", and this value (15001886) is in A3, which means that the formula is wrong?
Originally Posted by oeldere
@engen44,
in A11 you find the value 15001912 which is NOT found in column C.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks