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

Tamamlanmış İlan edilme: 2 yıl önce Teslim sırasında ödenir
Tamamlanmış Teslim sırasında ödenir

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 Veri İşleme Uygulamalar için Visual Basic Veri Girişi

Proje NO: #32631742

Proje hakkında

17 teklif Uzak proje Aktif 2 yıl önce

Seçilen:

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. Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(683 Değerlendirme)
7.4

Bu iş için 17 freelancer ortalamada $23 teklif veriyor

mrbrave

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(318 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(45 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(24 Değerlendirme)
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 Daha Fazla

$30 USD in 2 gün içinde
(3 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(10 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(11 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$12 USD in 2 gün içinde
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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, Daha Fazla

$10 USD in 2 gün içinde
(0 Değerlendirme)
0.0