Skip to main content

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.

@luis.espeleta  

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