Match Cells within Excel

$10-30 USD

Завершено

Опублікований

about 9 years ago

$10-30 USD

Оплачується при отриманні

I have two Excel files. Each has a column called "Keywords". They columns are not exact. I need the data from Sheet 2 copied to Sheet 1 in the same row with the exact matching column. Master File = All Filter Keywords to [login to view URL] Secondary File = Keywords to Match .xls If there is a keyword in the Secondary file (keywords column) that is an exact match of the Master file (keyword column), the data in the secondary row should be added to the row in the master file. I would like to have this complete within the next 17 hours at the latest. YOU MUST MENTION THAT YOU UNDERSTAND THE PROJECT TO BE CONSIDERED. FOR PROMPT SELECTION, GIVE ME AN IDEA OF HOW YOU WILL DO THIS SO THAT I KNOW YOU ARE THE BEST SELECTION.

ID проекту: 7284707

Про проект

11 пропозицій(-ї)

Дистанційний проект

Активність 9 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@kleverwork

Low price, very fast 15 years of experience in data analysis Best practices developing applications in Excel, Access and SQL

$25 USD за 0 день

5,0

(2 відгуки(-ів))

2,1

11 фрілансерів(-и) готові виконати цю роботу у середньому за $120 USD

@zExcel

Hi, I'll be happy to help you with this project. I understand the project and I intend to accomplish this task using vlookup formulas

$1 051 USD за 0 день

4,9

(265 відгуки(-ів))

7,7

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, databases and macros. I think this case is solved using vlookup only. I must see the Master file, but I think that's it. Check my reviews. They speak for themselves. Best regards

$30 USD за 0 день

5,0

(175 відгуки(-ів))

6,7

@nagybatonyi

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. If you open a chat I can immediately send you a working mockup showing the method (formulas) doing the job. Regards

$25 USD за 0 день

4,9

(61 відгуки(-ів))

5,7

@tomislav1975

Hi, I can do this, I think I understand what you need. Check my portfolio and reviews, contact me if you're interested. Thanks, ________________________________

$40 USD за 1 день

4,9

(34 відгуки(-ів))

5,2

@brinkaj

I understand that you have a second file with a keyword column but it is not in order and you want to add the rows from file 2 to file 1 where the keywords match, is this correct? If so I can do this job for you under the given time.

$30 USD за 0 день

5,0

(2 відгуки(-ів))

1,2

@dataexpert999

Hello Sir, I'm a data expert with 5 years experience. 57 wpm typing speed, fast usage of keyboard shortcuts are an extra.

$25 USD за 1 день

5,0

(3 відгуки(-ів))

1,4

@klingklang79

Good day! I am transport and traffic engineer. I find these kind of quests in everyday work with big databases I will you one exel function to locate matching value in secondary file and then another to check weather these two match (because of similar enters )

$25 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@rezaoz99

Dear employer, Hi, straight t the point, I am an expert user of excel. Right now I am 100 % free and available for your project. Just count me in and I will complete the project. Regards, Reza

$25 USD за 3 дні(-в)

5,0

(2 відгуки(-ів))

0,0

@datacana

Hello, I have completed your file. I can send it to you right the way. For example, key word 18+ in the "keywords to match" file is found in the third row in the main file, so the information in cell "B3" and "C3" in the secondary file is copied to "E3" and "F3" respectively. Thanks John

$17 USD за 1 день