VBA to Google App Script

Completed Posted 3 years ago Paid on delivery
Completed 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,

Excel VBA Google Sheets

Project ID: #27876682

About the project

3 proposals Remote project Active 3 years ago

Awarded to:

ilkecokay

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

€8 EUR in 1 day
(7 Reviews)
4.1

3 freelancers are bidding on average €13 for this job

SeanJacobFox

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

€22 EUR in 1 day
(6 Reviews)
3.4
arunkumar07

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 in 1 day
(0 Reviews)
0.0