Excel Audit

$10-30 USD

Completed

Posted

almost 9 years ago

$10-30 USD

Paid on delivery

I have an excel workbook that I can't get the Vlook up function to work. Using "find" can find the values, but VLookup won't. (I think it has to do with the excel workbook being created by exporting from Quickbooks). I need 2 things: #1- I have a workbook that has 3 sheets. I need 3 values from sheets 2 and 3 pulled (lookedup and placed) into sheet 1. Vlookup ColumnF on sheet1 and get the value from column A on sheet 2. Then use the value you found on Sheet 2 to vlook the value on Sheet 3. I did the first few manually and the values weren't found, so I filled in with N/A. Row #280 had matches so I put that in with comments explaining where the values are found. #2 - Explain why the Vlookup isn't working and how to fix it for future use.

Excel

Project ID: 8244397

About the project

6 proposals

Remote project

Active 9 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:

@redouaneaberdin

Hi there My name is Redouane I am very interested in your project. I await your response. thank you in advance.

$15 USD in 1 day

5.0

(15 reviews)

3.1

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

@robmark64

I have 15 years of experience with Excel. I have used Excel extensively to manage data. Vlookup is a common tool that I used.

$25 USD in 1 day

0.0

(0 reviews)

0.0

@TitoValle

A proposal has not yet been provided

$20 USD in 1 day

0.0

(0 reviews)

0.0

@soonerjohn

Vlookup is great for pulling information in, but sometimes other formulas such as Index Match can work better. I would take a look at the Vlookup formula, but also try it with Index Match. Either way, you will get an explanation and instructions on how to use whichever formula is successful moving forward.

$25 USD in 1 day