VBA to Google App Script

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,

Excel VBA Google Sheets

프로젝트 ID: #27876682

프로젝트 소개