Aug 20 2019 09:22 AM
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...
Aug 20 2019 09:40 AM
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"