MICROSOFT EXCEL FORMULA NEEDED

Fullført Lagt ut 5 år siden Betales ved levering
Fullført Betales ved levering

Excel Formula Needed For My Inventory.

I have 2 Sheets

1ST Sheet is my Inventory Sheet named "2018"

Serial Numbers are placed in Column "C" in Sheet 2018

2ND Sheet is my Sold sheet named "Sold05/02/2018"

Serial Numbers are placed in Column "c" in sheet "Sold05/02/2018"

In sheet "2018" Column M has the value "INSTOCK". In Sheet "Sold05/02/2018 Column M has the Value "05/02/2018

I want my formula to search for the SKU number scanned in Column "C" and search it in the field of Column "C" in both sheet then it replaces the value from Sheet "sold05/02/2018" in column M to the Column M in sheet "2018"

Note that the SKU number it searches to replaces can be in different field number so it has to scan the whole column

Dataregistrering Databehandling Excel

Prosjekt-ID: #16912873

Om prosjektet

30 bud Eksternt prosjekt Aktiv 5 år siden

Tildelt til:

sy3d

we can use index/vlookup to match the column c then we can extract sold quantities as far as sku are in different places, that doesn't matter, skus should be same in both sheets please share both sheets, i'll provide Mer

$60 USD på 1 dag
(362 omtaler)
7.4

30 frilansere byr i gjennomsnitt $93 for denne jobben

asifdwan

Hi there! I've read the project details and ready to start it right away. I'm an expert in data entry and data scraping jobs. I've huge experience in working on this type projects. I look forward to hearing from y Mer

$155 USD på 1 dag
(255 Omtaler)
7.2
Tanmoy236

"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business Mer

$50 USD på 3 dager
(274 Omtaler)
7.1
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

$55 USD på 1 dag
(332 Omtaler)
7.3
DanielVizcaya91

Hi there. My name is Daniel and I would be glad to help you out with this project. I have understood the formula you need, and I am positive I can achieve it for you. I would like to take a look at your excel file, to Mer

$149 USD på 1 dag
(108 Omtaler)
7.0
c4cuteconain

I am a professional accountant with a decade of experience working with excel in a US based NASDAQ registered company's finance department. can make you your excel formula as you described

$30 USD på 3 dager
(107 Omtaler)
6.1
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Mer

$150 USD på 3 dager
(34 Omtaler)
5.8
vlayausa

Hello, I am proficient with Excel and VBA and would love to help you with this problem. Please contact me for more information.

$51 USD på 3 dager
(141 Omtaler)
5.9
haleem0786

I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, chart, advance formulas etc. thanks

$70 USD på 1 dag
(27 Omtaler)
4.1
osamasuleman

Hello we are a team of chartered accountants, we have played with this type of data for many years. We can help you with yours as well. Lets chat to discuss it further and get your job done.

$49 USD på 1 dag
(1 anmeldelse)
0.3
phamzky

I am an expert in PDF & Specialist on Data Entry. My aim is to provide 100% accurate service to my clients. I am available 7 days a week & very active to respond messages. I have much experience of PDF editing and data Mer

$155 USD på 1 dag
(0 Omtaler)
0.0
fxfrans6

Good excel

$155 USD på 3 dager
(0 Omtaler)
0.0
sherifmao

i can help you at your project at fast time and great performance if you hope to work with me, please get me permission to work at your project at near time

$40 USD på 2 dager
(0 Omtaler)
0.0
jatinsinghi

"Dear Next Employer We will give you the best result by using my Past experience and excellent academic skills on your project. You can chat with me and let's get started.

$100 USD på 2 dager
(0 Omtaler)
0.0
JIMMYPATEL422

I'm a professional data entry expert. I am here to help you to promote your business with 100% satisfaction. I will provide you fast and reliable service. I'm offering following services in this gig Online/offlin Mer

$155 USD på 3 dager
(0 Omtaler)
0.0
nguyenban88

Hello i have read your request and would like to cooperate for you on the job, please contact me, i will do my best, thank you MICROSOFT EXCEL FORMULA NEEDED

$55 USD på 1 dag
(0 Omtaler)
0.0
mahmoudkz

I have been able to work in companies of this type for several years but I am now starting to work on the site with sufficient experience in such jobs qualify me to get it I promise you that I will accept my offer a Mer

$45 USD på 1 dag
(0 Omtaler)
0.0
gurramsivakrishn

Hello, I have found your project interesting & very familiar to me. I have worked on 2 similar stock related projects & many excel related projects. I can finish off your work with high satisfaction Relevant Skills Mer

$35 USD på 2 dager
(0 Omtaler)
0.0
husnahakim

Hai!May God bless you wherever you are! I am interested in job related to excel. I am interested to do this job where I can fully utilize my skills and make a significant contribution to the success of the employer Mer

$111 USD på 5 dager
(0 Omtaler)
0.0
AnteMijic

Hi, the task you are asking is quite simply solved. Just send me a message and I will do it! I work as a DWH programmer, so I am quite familliar with all kind of database problems :)

$55 USD på 1 dag
(0 Omtaler)
0.0