Make formula change horizontally

[Godtooro]

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!

[#2]

Your question doesn't make sense. Add few sample data. You may try XLOOKUP() or HLOOKUP().