Transform Office 365 Excel sheet with XLookup to make compatible with old versions of Excel
$10-30 USD
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
Proje NO: #32631742
Proje hakkında
Seçilen:
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
Bu iş için 17 freelancer ortalamada $23 teklif veriyor
Hi, Without using VBA, this can be done combining Excel functions. XLookup is just a combination of old functions. Available to convert now..
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
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
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
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
Hi, I have read your description over. I can help you convert XLOOKUP to VLOOKUP formula. Please chat me. Best Regards, -Lan
Sir I do this job please contact me sir my excel experience is 3 years my accounting field I do my best
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
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
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