itsmevic
asked on
Excel 365: Formula That Compares a set of Numbers against a column of Numbers, then notes what numbers it finds
Hi Experts,
I have a worksheet that consists of numbers in Column A, 100 rows to be exact. What I'd like to do is have a formula that first looks at the numbers in column D, and then checks Column A to see if any one of those numbers are present. If the formula detects any of the numbers that were noted in column D, it then notates what numbers it found in Column B. I've attached an example of what I'm describing. Any help with this is GREATLY APPRECIATED!
EXAMPLE.JPG
I have a worksheet that consists of numbers in Column A, 100 rows to be exact. What I'd like to do is have a formula that first looks at the numbers in column D, and then checks Column A to see if any one of those numbers are present. If the formula detects any of the numbers that were noted in column D, it then notates what numbers it found in Column B. I've attached an example of what I'm describing. Any help with this is GREATLY APPRECIATED!
EXAMPLE.JPG
Can you upload a sample file rather than screen shot?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you!