In Progress

Need two excel formula for data (index)

I need an excel formula kind of an INDEX/MATCH but the thing is the match is on another row. Please see the [login to view URL] ... In the end, I'm looking to have a list of all the green cells and I need the yellow cells besides. The yellow cell is always in the third row after vendor totals.

Please see the .xlsx I attach, there are only five values to fill but if you find a way to do it for those 5 with a formula, I will be able to apply it for all my document.

Thank you!

Skills: Excel, Data Processing, Data Entry

See more: excel formula capture data time day, need excel macro input data, excel fetch data web site need log, index match match excel, excel match function, index match multiple columns and rows, excel array formula multiple criteria, index formula, index match vlookup, excel index match multiple criteria, index match function excel, free data entry excel formula urdu, concatenate data excel formula, index excel formula, need someone consolidate data separate excel spreads, need excel formula programming, need excel formula expert, need export linkedin data excel, need someone consolidate data separate excel spreadsheets, need huge sample data excel

About the Employer:
( 1 review ) Sherbrooke, Canada

Project ID: #27960978

Awarded to:


Hi There, >>>> Work Already done with new sheet proposal >>>> See links Interested in your posting as I’m used to perform such project. I already run a draft for your work and I’m ready to finalize right away if yo More

$15 CAD in 1 day
(2 Reviews)

25 freelancers are bidding on average $21 for this job


(443 Reviews)
(290 Reviews)

Hello, i looked at the attached document and the pictures, and i would honestly suggest that you consider macros for this, since there are variable number of rows per item. If you are interested in working with me, fee More

$20 CAD in 1 day
(564 Reviews)
(136 Reviews)

Hi, I have written 2 excel formulas that extract all "Green" and "Yellow" values and it works perfectly. But I have to use helper column for identification green cells. Let’s discuss if you’re interested. Best regards, More

$30 CAD in 1 day
(51 Reviews)

Hi there I would love to help you with the excel index formula. I'm an Expert in Excel complex formulas. You don't need any VBA/Macro, this is a pure excel formula. I would love to show you, Please text me. Thanks

$20 CAD in 1 day
(25 Reviews)

Hello! I have checked your spreadsheet and I can help you with it. Just message me for discussion. thanks!

$25 CAD in 1 day
(39 Reviews)
(52 Reviews)
(17 Reviews)

Hi, I have more experiences in Visual Basic, MS EXCEL and VBA. I am ready to build a Macro to make this matching. Feel free to discuss. Thanks

$30 CAD in 2 days
(14 Reviews)

✅ Expert on Advanced Excel ✅ Hi there! I’m expert on Advanced Excel, VBA, Macro, match, index, vlookup, hlookup, array, nested if, countifs etc Complex Formula, Excel automation and Microsoft Excel related various admi More

$20 CAD in 1 day
(36 Reviews)

Hi there. My name is Benne and I'm an Excel enthusiast/trainer/solutionist. It's about detecting patterns, so maybe we can discuss how. How do Excel knows to take the green cell for eg? Whenever column B shows "A"? More

$20 CAD in 1 day
(6 Reviews)

Hi.. I can do this match of data for you accurately as per your requirements. Please text me so that we can discuss about this further.

$14 CAD in 1 day
(12 Reviews)

Dear Hiring Manager, Thank You for posting the job opening in excel spreadsheet. I can solve your problem with formulas in Excel spreadsheet. I have 4 year of experience with advance Excel working. I have perform all More

$15 CAD in 1 day
(4 Reviews)

To whom it may concern, I am available to discuss the project and ready to start work. Excel is one of my favourite programs. I have more than 5 years of experience. I use Excel and other Microsoft programs on a daily More

$20 CAD in 7 days
(0 Reviews)

Greetings, I understand your proposal that what you want actually. I can do this easily and complete it within few hours. Regards M Rafique

$18 CAD in 1 day
(0 Reviews)

I am professional data entry export. I can assure you,that I shall give you top class work. I will do your work honestly. You will like to come back to me again and again. Thank you sir...For reading

$10 CAD in 7 days
(0 Reviews)

I am give 100% accurate work nd submit it within a 5 days i am expert in data typing and analysis. Good ms excel skill.

$20 CAD in 5 days
(0 Reviews)

Good day. I'm very much interested in your project. I'm good in Excel (index). I've been a staff in a manufacturing company in the Philippines for 15 years doing data entry. I'm proficient in Excel, Word and Powerpoin More

$25 CAD in 1 day
(0 Reviews)

I can create this for you as I am well experienced on this. if offered i can assure of 99% accuracy.

$18 CAD in 5 days
(0 Reviews)