Find Jobs
Hire Freelancers

Excel lookup function variation

$30-250 USD

Terminado
Publicado hace alrededor de 8 años

$30-250 USD

Pagado a la entrega
We use vlookup functions in lots of spreadsheets to return lookups - typically product categories based on stock codes. This is messy as (1) sometimes the lookup table data does not return a result and you get #N/A, & (2) we also must populate many spreadsheets with the same data and (3) keeping everyone using the same definitions of the table is awkward. We want some simple functions that do the look up job for us. The basic data is like this: Full_Code Short_Code Sub_Category Category xyz233 xyz storage heater water heaters sdde223 sdde fan heater room heaters etc So we currently use formulae like =VLOOKUP(A1,range, 2,false) to return xyz from xyz233 but this is not ideal for the above reasons. What we want is three functions that are self contained (eg the data is embedded in the function) so we can just call function that do the lookup for us: 1. Shortcode (Full_Code) returns the Shortcode (eg Shortcode("xyz233") returns "xyz" 2. SubCategory ("xyz") returns ("storage heater") 3. Category ("storage heater") returns ("water heaters") If in any case the argument is not in the table the function should return ("unknown"). The table could be about 1000 Full_Code rows long and we might call it many thousand of times in a spreadsheet, so performance matters ! (vlookup easily works fast enough). Its fine to break the table up into "relational" fragments - the higher level Category function will only have 10-15 entries. We can sort data by frequency if helpful. The functions should be stored (I recall there is a way I think) so that any new spreadsheet can just call the functions as if it was part of excel. We can edit the function definitions for maintenance. Note I have avoided suggesting the data is in a table in a different spreadsheet. This seems to have been slow and cumbersome in the past. We can maybe do it this way if there is no choice, but rather not. I will send the table to the winner.
ID del proyecto: 9419158

Información sobre el proyecto

14 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
Hello, your requirements sound very familiar to me, I have a rich experience and have done a lot of similar tasks. It would be easy and also fun for me to create a script which would do all that you described in project description. I would really enjoy in making it. Also, I will respond quick to additional requests, if you have any after I finish the macro. Please contact me to discuss further details. Regards, Ivan
$98 USD en 3 días
5,0 (3 comentarios)
2,7
2,7
Avatar del usuario
Hi! i would suggest you to use INDEX, MATCH function instead of vlookup and also IFERROR should be used to avoid #N/A. Send me chat to get sample file.
$79 USD en 3 días
5,0 (106 comentarios)
5,6
5,6
14 freelancers están ofertando un promedio de $110 USD por este trabajo
Avatar del usuario
Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful
$155 USD en 3 días
4,9 (100 comentarios)
6,1
6,1
Avatar del usuario
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.
$75 USD en 1 día
5,0 (57 comentarios)
5,7
5,7
Avatar del usuario
Hi there My name is Redouane I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you
$45 USD en 1 día
5,0 (50 comentarios)
4,4
4,4
Avatar del usuario
----------------------Very nice Job!I master in your task!Best result on time!---------------------------------------
$210 USD en 3 días
5,0 (2 comentarios)
1,8
1,8
Avatar del usuario
Hi, I would like to offer you my services. I have 7 years of experience and i am very expert in excel.I can do any task on excel with a blink of an eye because i know the importance of time. Although i am a new freelancer but i am very hardworking. If you give me a chance to work on your project i will really appreciate that. I will look forward to work with you. Thanks Arslan Ahmed
$110 USD en 1 día
5,0 (2 comentarios)
1,6
1,6
Avatar del usuario
I have excellent command on MS Excel. I have completed complex projects in Excel before as seen in my portfolio. (like - built a reservation system in Excel that involved formulas and Macros to consolidate data from various sheets and pricing calculation.)
$100 USD en 3 días
5,0 (2 comentarios)
1,2
1,2
Avatar del usuario
I have the all skills required to complete your project, not only I'm skilled but also experienced for this work just need a chance to prove myself.
$30 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear Hiring manager, I’m skilled and experienced researcher and data entry person. I have good working experience with Excel vlookup and Google spreadsheet. If you consider me for this project, I will try to my best. I look forward to hearing from you. Regards Joynul
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am a full time software engineer and have been since the age of 18. I have vast experience in multiple languages, including Visual Basics, c#, Asp.NET, C, C++, Java, NodeJs etc etc.
$77 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Harrogate, United Kingdom
5,0
68
Forma de pago verificada
Miembro desde jun 9, 2008

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.