VBA to Google App Script


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


End Function


Evner: Excel VBA, Google Sheets

Se mere: google sheets developer, google sheets macros examples, google sheets macro button, vba in google sheets, import excel macro to google sheets, google sheets macros language, google apps script, google script, joomla google app, build social networking site google app engine, google blogsearch script, publish google calendar script, sql google map script, add google analytics script, google translation script, video google api script, python rss script google app engine, string app script google, Google app script, google app script tutorial

Om arbejdsgiveren:
( 1 bedømmelse ) Paris, France

Projekt ID: #27876682

Tildelt til:


Hello I will do this project for you for the lowest price possible. Message if interested. Best regards.

€8 EUR på 1 dag
(7 bedømmelser)

3 freelancere byder i gennemsnit €13 timen for dette 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 Flere

€22 EUR på 1 dag
(6 bedømmelser)

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

€8 EUR på 1 dag
(0 bedømmelser)