Need help with Excel VLookup and IF functions

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

Trying to automate a labor union payroll and need a multipurpose spreadsheet that will work as a training tool for my staff, a replacement for hand-written and manually calculated pay, a reliable audit tool, and will also work as an illustration for our payroll service provider as we work together to automate labor union payroll with multiple pay rates, shift codes, and pay rules. I started on a worksheet that is about 80% reliable, but need help inserting "IF" functions into VLoookup formulas.

Excel

Project ID: #16388005

About the project

17 proposals Remote project Active 6 years ago

Awarded to:

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$50 USD in 1 day
(325 Reviews)
7.3

17 freelancers are bidding on average $113 for this job

Tanmoy236

"I am extremely good with Excel as it is part of my daily professional work. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with ma More

$40 USD in 3 days
(234 Reviews)
6.9
usmanhassan123

A proposal has not yet been provided

$250 USD in 1 day
(72 Reviews)
6.2
satishtl

- Can get the formulas fixed, have expertise in formulas, lookups, if functions, summaries and pivot. - Have worked on complex solutions in Excel. - Have done complicated payroll system in Excel for a Aussie company, More

$40 USD in 0 days
(48 Reviews)
6.0
whitehorsetechn

Greeting, I have understood your Need help with Excel VLookup and IF functions task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Excel

$100 USD in 2 days
(13 Reviews)
5.2
katiewells3

I am an Australian Business Analyst with 15 years of professional experience building high level Excel solutions (including VBA / macros, PowerPivot, SQL connections etc.). I would love to take a look at your sheet and More

$166 USD in 3 days
(28 Reviews)
5.1
LeahAnson

I am an organized, experienced professional with more than fifteen years of experience. I have held titles such as Publishing Assistant, Administrative Assistant, Office Administrator, Insurance Administrator, and Gra More

$188 USD in 3 days
(8 Reviews)
3.8
haleem0786

I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas etc. do let me know more detail in PM. thanks

$70 USD in 1 day
(24 Reviews)
4.0
rhodelta

Experienced Excel user with office and technical background. I have a lot of experience with IF and VLOOKUP. Sounds easy enough but I'll need to see the actual spreadsheet.

$166 USD in 3 days
(5 Reviews)
2.6
zahidmohoboob

Dear Sir, I wish to submit my application for this job. Equipped with a Master in Financial Economics and a Bsc (hons) in Economics and Finance, I have eight years of professional experience in the field of Financi More

$55 USD in 3 days
(1 Review)
1.0
asadrehman654

hi, I'm interested in your project. Please send me a message so that we can discuss more. Thanks Asad

$155 USD in 3 days
(0 Reviews)
0.0
LeThiLan

Hello, My name is Lan. I am available right now. I can turn around quicky. I am good skills with excel formula

$88 USD in 1 day
(0 Reviews)
0.0