Excel Formula
- or -
Post a project like this2456
$$$
- Posted:
- Proposals: 6
- Remote
- #1641675
- Awarded
Excel Wiz, VBA Specialist, UI and Usability Designer, Business Analyst, Agile Practioner, Data Analyst
Bangalore
Web research|Lead Generation| email database | Linkedin Research | Data Research | Image annotation
Mumbai
886898665266768831120790112671401420339
Description
Experience Level: Expert
Description of excel work: To start I need a quick formula. To best describe this I would suggest showing you on SKYPE or some other format similar. I have multiple data file (one with over 200,000 rows, I need a function that identifies (search) for two different specific values in cells on one sheet in another sheet. I'm using the following but its not working for me; =INDEX('DS Import Data'!$D$2:$V$9930,MATCH(1,('DS Import'$D$2:$D$9945=K4)*('DS Import Data'$H$2:$H$9945=B16),0,15)
After that I'm looking assistance in building an excel system to extract reports and statements from this extensive data which will be a separate and bigger project.
Extra notes:
After that I'm looking assistance in building an excel system to extract reports and statements from this extensive data which will be a separate and bigger project.
Extra notes:
Derry T.
87% (3)Projects Completed
4
Freelancers worked with
4
Projects awarded
43%
Last project
28 Jul 2017
United Arab Emirates
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies