Hello, I have the following Excel formula that I'm implementing in the "Set Cell Formula" action: =VLOOKUP(X2;Sumarias!C:D;2;0), however, I want to modify it to search in the worksheets: Sumarias_JDV and Sumarias_SC. I made this modification but it didn't work: =VLOOKUP(X2;INDIRECT('Sumaria_JDV'!C:D;'Sumaria_SC'!C:D);2;0)
Thank you in advance.
Set cell formula
+3
+4
Can you replace semicomma with comma and give it a try. if it helps please mark as resolved
=VLOOKUP(X2, INDIRECT('Sumaria_JDV'!C:D, 'Sumaria_SC'!C:D), 2, 0)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.