SOLVED

Buscarh, hlookup

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3148622%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Bes-ES%5C%26quot%3B%22%3EBuscarh%2C%20hlookup%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3148622%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Bes-ES%5C%26quot%3B%22%3E%3CP%3EGood%20afternoon!%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20am%20not%20able%20to%20figure%20out%20why%20''future%20sales''%20is%20giving%20me%20an%20error.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20for%20the%20help%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F347007i326BEE5440AE9F77%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Screen%20Shot%202022-02-10%20at%2012.53.43%20PM.png%22%20shot%3D%22%22%202022-02-10%3D%22%22%20at%3D%22%22%2012.53.43%3D%22%22%20pm.png%3D%22%22%20alt%3D%22Screen%20Shot%202022-02-10%20at%2012.53.43%20PM.png%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3148622%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Bes-ES%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3ECharting%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EExcel%20on%20Mac%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

Good afternoon!

 

I am not able to figure out why ''ventas futuras'' is giving me an error.

 

Thank you so much for the help

 

 

 

Screen Shot 2022-02-10 at 12.53.43 PM.png

4 Replies
I think the problem is X3, it might not be finding a referenced value. How can I make it be one?

Thank you
You should try M3 instead of M4 for Table Array.
best response confirmed by PabloGil (New Contributor)
Solution
I mean $M$3:$R$16
Thank youuuu!!!