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
VLOOKUPFILTER = ""