Hello.
I have two Excel files, which I put in the attachment.
I am looking for some method that will simplify the work.
In file 1 there are numbers in column E
In file 2 there are also numbers in column C
The formula is supposed to work like this. If there is the same number in column 1 and 2, then "YES" near number should be written in file 2. in column E. However, if the file 2 contains a number that is not in the file 1. it is to be written with "NO"
2497938600_1554072101.jpg
Hi, welcome to the forum
No, you only attached 1 excel file?Originally Posted by locarnos
Maybe something like countif, inside an IF statement?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
File 1 is in CSV. But you can convert it to xlsx or something.
Please Login or Register to view this content.
Last edited by protonLeah; 04-07-2019 at 03:37 PM.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks