Transform Office 365 Excel sheet with XLookup to make compatible with old versions of Excel

Concluído Postado há 2 anos Pago na entrega
Concluído Pago na entrega

I have an Excel sheet that uses XLookup formulas to calculate numerous values in certain columns based upon other values in the sheet. There are other people working on the Excel that do not have the version that I am working on and do not have access to use the XLookup formula. I need a replacement sheet that behaves identical. You are free to use Macros/VBA but it must be non-interactive (automatically calculate the values).

--> Acceptance criteria is that the sheet looks and behaves exactly like the original one and opens in an older version of Excel

Excel Visual Basic Processamento de dados Visual Basic para Apps Processamento de Dados

ID do Projeto: #32631742

Sobre o projeto

17 propostas Projeto remoto Ativo em há 2 anos

Concedido a:

MimiFL

Hi, i believe i can replace xlookup formulas for you in matter of minutes. If you are interested, feel free to message me, so i can ask few follow up questions. I am available right now. I have a sample ready for you. Mais

$15 USD em 1 dia
(683 Comentários)
7.4

17 freelancers estão ofertando em média $23 nesse trabalho

mrbrave

Hi, Without using VBA, this can be done combining Excel functions. XLookup is just a combination of old functions. Available to convert now..

$15 USD em 1 dia
(318 Comentários)
7.0
hamidr2020

Hi, I have checked the formulas and know/comprehend their use in the attached sheet. I can help to replace XLOOKUP formula with formulas compatible with old versions of Excel. The people with old versions will also be Mais

$17 USD em 1 dia
(45 Comentários)
5.1
AAGGMM

Hello sir I am Ahmed, a data analytic with very good skills in Excel [advanced formula, macros, power query and pivot table],SQL and R-Programming language, also in data processing, cleansing, organization, and integ Mais

$30 USD em 1 dia
(24 Comentários)
4.4
varimaxanalytic

Hi! I am really interested in this job. I’m data scientist working remotely with various analytical companies. I’m offering best quality and highest performance at a price we are both comfortable with. I can complete Mais

$30 USD in 2 dias
(3 Comentários)
3.6
EmiliaSimon

Hello, I have seen your requirements and I am ready to help you transform XLOOKUP functions. I am a Data Analyst with extensive experience in managing Excel spreadsheets, nested formulas, lookups and VBA/macros, and I Mais

$20 USD em 1 dia
(10 Comentários)
3.6
jinhui12

Hi, I have read your description over. I can help you convert XLOOKUP to VLOOKUP formula. Please chat me. Best Regards, -Lan

$10 USD em 1 dia
(11 Comentários)
3.1
adnanboss7890

Sir I do this job please contact me sir my excel experience is 3 years my accounting field I do my best

$10 USD in 7 dias
(0 Comentários)
0.0
LSamaral

First of all I would like to say that I speak English in an intermidiate level (I am taking a course right now), If you want to check my level of communication in English, just text me and we can talk before closing th Mais

$12 USD in 2 dias
(0 Comentários)
0.0
dviray21

Hello! I have extensive experience and advance MS Excel skills and I believe I am capable to do this task. Xlookup can be easily replaced by other functions without the use of VBA. Hit me up so we can discuss this furt Mais

$14 USD em 1 dia
(0 Comentários)
0.0
mohammadfalahat

Dear Sir, I am a programmer, excel VBA developper, and an electrical engineer. I am very confident in my ability to solve this challenge to your full satisfaction of quality and time. Because I am new to this website, Mais

$10 USD in 2 dias
(0 Comentários)
0.0