Forum Discussion

Godtooro's avatar
Godtooro
Copper Contributor
Apr 01, 2024

Make formula change horizontally

Dear all!

 

I've the next doubt:

 

  • I've this formula: =+VLOOKUP(E3;[Excel_Control.xlsx]CALCULO_1!$B$84:$AR$101;43;0)

Do you know how to make that changes to horizontally:
=+VLOOKUP(E3;[Excel_Control.xlsx]CALCULO_1!$B$84:$AR$102;44;0)


Thank you for your support!

excel
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Apr 01, 2024
    Your question doesn't make sense. Add few sample data. You may try XLOOKUP() or HLOOKUP().

Resources