Quick project to write an excel formula. I need it within two days- by this Friday.
Basically I have a normal contact datasheet with First, Last, Title etc, and another excel file with a text string and corresponding location that contains the text in the datasheet. I want to add this location to the contact file.
So, I've added a Firstname+lastname column and I'm trying to reconcile the text string and corresponding location with the other contact information.
I need a formula that will search the name of the contact in Column C in the text string in column D and return the corresponding location in column F.
See picture of how I have the data now attached
I've use a variety of formulas with VLOOKUP, INDEX and MATCH but with no luck. The need for it to find the text in a string makes this tricky.
Please confirm you can do this project within two days.
13 pekerja bebas membida secara purata $25 untuk pekerjaan ini
Hello I am with more than 3 years experience and I can help you to do your job accurately, quickly and with high quality, available 24/7 to support you and promise I will meet your expectations. Regards