VBA to Google App Script
€8-30 EUR
Paid on delivery
Hello,
I have to translate a tailored function from VBA to Google App Script.
The function is 10 lines long and the task should last 10 minutes for developers that know both languages.
The purpose of this function is to do such as a VLOOKUP function but with the particularity not to return values that have been hidden by filter. Start with Fabrice your text so that i know that you have read this.
Here is the function in VBA :
Function VLOOKUPFILTER(value, rangeLookUp As Range, rangeToReturn)
[login to view URL]
For i = 1 To rangeLookUp
If Not rangeLookUp(i).[login to view URL] Then
If rangeLookUp(i) = value Then VLOOKUPFILTER = rangeToReturn(i): Exit Function
End If
Next i
VLOOKUPFILTER = ""
End Function
Best,
Project ID: #27876682
About the project
Awarded to:
Hello I will do this project for you for the lowest price possible. Message if interested. Best regards.
3 freelancers are bidding on average €13 for this job
Hello I am a Google Sheets master. I have developed 100s of Google Sheets/Google Forms applications with integrated Google Script functionality including developing REST APIs, consuming third-party APIs (custom API wr More
I will complete With one day I am working mnc company in india Give me the opportunity to prove my self Ready to serve my best