Lookup data in 2 pivot tables

$30-250 USD

Completed

Posted about 7 years ago

$30-250 USD

Paid on delivery

I have an excel workbook that brings in data using an ODBC connection - these are production records from jobs produced. I'm trying to create a Vlookup in the "Waste Pivot" sheet that takes a value (prod order) in that pivot, looks up that order in the sheet 2 pivot, and returns the value in the "sum of qty" field. From what I can tell, you can't use Vlookup with pivot tables...

Project ID: 19478374

About the project

6 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@haleem0786

i can do this. i have good command over Ms excel especially pivot able, charts, advance formulas, formatting, macro etc. Please inbox me and share detail. Thanks

$60 USD in 1 day

4.9

(18 reviews)

3.8

@writingapp

Hi. Great app writer for your projects. I have writen excel vba for many years. I am ready to write your project. Thank you for visiting my profile

$40 USD in 2 days

0.0

(0 reviews)

0.0

6 freelancers are bidding on average $87 USD for this job

@bhupendrayadav

I am postgraduate (MBA) in finance with more than 5 years of experience in financial modeling, advanced excel based tools, VBA automation, and data processing. I have successfully completed similar projects, please have a look at my portfolio for more details on my previous work and expertise. I have successfully developed couple of automation tools for Ernst & Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you

$200 USD in 1 day

4.8

(23 reviews)

4.4

@Monirulop

Hi, I am Monir and it will be my pleasure to assist you with this project. I have read your project description. You can expect from me I strong commitment to a deadline, the highest quality, and a fluid/friendly communication. Client satisfaction is my ultimate goal. I look forward to working on this project. I would be glad to chat with you to see how I can help. Thank you for your time and consideration. Don't hesitate to contact me if you are interested, I am sure I will not let you down. Thanks & Best Regards Monir

$30 USD in 0 day