Need help on troubleshooting Macro and #N/A issues

Copper Contributor

Hi everyone,

 

I'm having issues with this spreadsheet. For some reasons, I could not get cell A28 with formula =CELL("address",INDEX($B$34:$EL$34,MATCH(A27,$A$34:$EK$34,1))) to return a number figure.  

 

Any help would be appreciated...

 

 

clipboard_image_3.png

 

clipboard_image_4.png

 

clipboard_image_5.png

 

 

1 Reply

@Jexce1123 

What you try to return? =CELL("address", reference") returns address of the first cell in the reference as text, e.g. cell("address",A1:X1) returns "$A$1"