I need a simple excel formula which allows me to do the following:
**** All Formulas must be in Sheet2 Only
1. Lookup for values that are in Sheet2 Columns A and see if any of the cell values are found in Sheet1 Column D.
2. If found, Enter Date and Time in Sheet1 Column E right next to the matching value and highlight with green colour.
See Excel file attached for more details.
12 freelancers are bidding on average $12 for this job
Hi, I have understand the project requirement & interested to make formula for this project. Please send a message so we can discuss more & start the project. Thanks.
I'm a dedicated and hardworking person who believes in honesty and good working relation. Though I'm new at this sector of job but I've certain qualities which makes me good at this
Hi, I have much experience in MS Excel and it's power tools like Vlookup, macro etc. Hope this will be enough for you ! Surprise, Your file is ready ! Waiting for your favourable reply !