Find Jobs
Hire Freelancers

Do some Excel Work

$15-25 CAD / hour

Terminado
Publicado hace más de 8 años

$15-25 CAD / hour

I am creating an Excel spreadsheet that requires VLOOKUP referencing - and possibly other advanced Excel tools. I have formatted the overall worksheets but need help with bringing it all together with lookup codes. This will be an ongoing project as I want to add additional features as the business grows. I want to automate as much as possible. This initial work won't take too long. Q - When doing VLOOKUP I keep getting #N/A error messages because fields are empty. Can empty fields return a result that is simply BLANK?
ID del proyecto: 8885111

Información sobre el proyecto

65 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi! The error due to blank cells can be avoided using IFERROR or IF(ISERROR functions. Please share the file and I am ready to start working on it right now.
$15 CAD en 3 días
5,0 (382 comentarios)
7,5
7,5
65 freelancers están ofertando un promedio de $19 CAD /hora por este trabajo
Avatar del usuario
A proposal has not yet been provided
$25 CAD en 2 días
4,9 (321 comentarios)
7,3
7,3
Avatar del usuario
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$22 CAD en 1 día
4,9 (230 comentarios)
6,9
6,9
Avatar del usuario
Hi There, My name is Priyal. I’ve read your brief and happy to discuss the project in more detailed. I am an expert in all advanced excel formulas including vlookup, hlookup etc. If you'd like to view my qualifications, experience and previous work, take a look at my Freelancer Portfolio I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards,
$15 CAD en 4 días
5,0 (195 comentarios)
6,8
6,8
Avatar del usuario
Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful
$22 CAD en 3 días
4,9 (162 comentarios)
6,7
6,7
Avatar del usuario
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
$15 CAD en 1 día
5,0 (256 comentarios)
6,5
6,5
Avatar del usuario
Hello, I am Excel and VBA expert. I can write a macro (if needed) and/ or formulas. P.S. VLOOKUP can return #N/A error, but you can easily avoid this error Regards Jan
$15 CAD en 3 días
5,0 (94 comentarios)
6,0
6,0
Avatar del usuario
Hi, I am very good in EXCEL and VBA programming so I can help you with this project in minimal time. as I have worked on similar projects many times :) Regards.
$15 CAD en 2 días
5,0 (26 comentarios)
5,3
5,3
Avatar del usuario
Hi, I am a scientist by profession with extensive experience in creating Excel platforms for reformatting, organising and analysing large data sets. I believe I will be able to help you create an attractive, easy-to-use and error-free spreadsheet , and I will be more than happy to help expand its functionality wherever needed in the future. I have a lot of experience with VLOOKUP referencing. The #N/A error can be fixed by simply adding in an =IF(ISERROR(XXX)=FALSE, logic gate which evaluates to a blank if the formula would otherwise return an error. Please check my portfolio for other examples of complex Excel tasks I have undertaken in the past. Thanks for your consideration, Dan
$20 CAD en 3 días
5,0 (52 comentarios)
5,1
5,1
Avatar del usuario
Hi, For your problem you must use VLOOKUP with IF and ISERROR The format is like this =IF(ISERROR(VLOOKUP...),"",VLOOKUP(same vlookup)) I am not interested in hourly contracts, if you especially need macro solutions find me... Regards,
$27 CAD en 3 días
5,0 (21 comentarios)
4,4
4,4
Avatar del usuario
Can empty fields return a result that is simply BLANK? Answer : Yes. Formula = IF(A1="","",YOUR VLOOKUP FORMULA) I'm very well-verse in spreadsheets and Microsoft Excel, particularly strong in Formulas, V-Lookups, Pivoting, conditional formating, filtering and sorting.I also develop Professional Dashboards for Corporates with thier themes & SME as well. All work is delivered with high quality standards, without errors.I'm looking forward to serve you, on your available task.
$15 CAD en 1 día
4,7 (43 comentarios)
4,6
4,6
Avatar del usuario
=IF(ISERROR(VLOOKUP(A;B;C));"";VLOOKUP(A;B;C)) I have a better way to do this though: The INDEX function has a better functionality for your needs since VLOOKUP just find the searched value into the first column of the range you input. I have 15 years of experience on this! You can take a look to my portfolio in order to see what I can do for you!
$22 CAD en 3 días
4,9 (15 comentarios)
4,1
4,1
Avatar del usuario
I am ready with the job .. Lets discuss your job in detail .then pass me a sample work so that i show my work to you. finally we can discuss the payments as well as the milestones.. please don't hesitate to contact me, thank you.
$15 CAD en 3 días
4,9 (18 comentarios)
3,8
3,8
Avatar del usuario
Hi,,,, if you want to someone help you with VLOOKUP function, i am pretty sure that there is going to be a lot of people that it may help you, BUT if you want someone with a good experience doing automate files in excel,,, I AM THE ONE,,, because sometimes you have to use other functions and know how to use it to improve the task.
$15 CAD en 5 días
4,8 (13 comentarios)
3,9
3,9
Avatar del usuario
30 years in business computing University Degree in Systems Analysis expert in data manipulation expert in Excel specialise in user friendly solutions accuracy assured available to start immediately
$15 CAD en 3 días
5,0 (5 comentarios)
3,8
3,8
Avatar del usuario
Hello Dear, I have experience in this project & other task easily and having ability to give back to you fine results. I can do it for good review. Money is no problem. So please just accept me . I am ready to start. Waiting for your reply. Thanks misuxn
$15 CAD en 10 días
5,0 (6 comentarios)
2,6
2,6
Avatar del usuario
I am passionate about excel and use it daily in my office ( I head a business analysis and planning department of a telecom company). I am not doing projects for just money but, because i love doing such tasks. I am skilled with using lookups through VBA and in excel (Vlookup, index/match are my specialities).
$16 CAD en 5 días
5,0 (3 comentarios)
2,3
2,3
Avatar del usuario
I am an expert in VBA/Excel/Access and web solutions, with several years of experience in developing VBA/Excel/Access/Web based applications for different business needs. My level of expertise allows me to implement high quality solutions within very affordable budgets. I have a bachelor’s degree in Computer Science and worked for many organizations around the world. Now I am working as a full-time freelancer which makes my mission being strictly to assist people and organizations in creating and implementing solutions for theirs business. Hire me and get professional solutions for your business. At your service,
$15 CAD en 30 días
5,0 (1 comentario)
1,2
1,2
Avatar del usuario
Dear Sir/Madam, I like to use excel to perform data entry and data analysis. In my previous working experiences, I used Excel workbooks and joined them together to create a demand planning system. I used a lot of vlookups, pivot tables, advanced formulas, etc... Regarding your question, using the ISNA function can solve your problem. I want to be in your team and do some projects with you. I look forward to hear from you soon. Cheers, Cal
$15 CAD en 10 días
5,0 (1 comentario)
0,8
0,8
Avatar del usuario
Dear employer, I can help you with the Vlookup formulas and I am currently available. A: to avoid the N/A, add "=if(isna(vlookup(...);"";vlookup())" to the formulas Have a nice day. Matias
$22 CAD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hey, I'm super proficient in excel. English is also my first language so there will be zero communication problems. I don't have a track record of completed jobs as I'm usually the one doing the hiring :)
$22 CAD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CANADA
Stouffville, Canada
5,0
6
Forma de pago verificada
Miembro desde mar 11, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.