Question

Set cell formula

  • 28 February 2024
  • 1 reply
  • 54 views

Badge +3

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.


1 reply

Badge +4

@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