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.
Question
Set cell formula
+4Can 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
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.