Can't get INDIRECT function to work.

Question

I was using MMULT(Transpose(Indirect(REF)),Indirect(REF)) where REF holds the range and it was working fine for matrix multiplication. Now, I'm getting errors. It works for Transpose(Indirect(REF)), Max(Indirect(REF)), and other array functions, but now, it stopped working for MMULT. Anyone have any idea what's going on? The cell REF holds a value like G4:H18 or some similar range. Any help is appreciated.

Answer 1

Okay, I found my problem. It had nothing to do with the function. It was my own mistake. I mis-specified the reference itself. My goof -- but I hope it helps others with a similar problem.

Answer 2

Hi,

It's good thing that you found the resolution on your problem and we will appreciate if you can share to on this thread on how it was resolved so that it will also help with the future users like me.

Thank you!
Myk
Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

Answer 3

Mukesh, thanks for you reply, but the fact that the indirect function works with other array functions such as MAX, MIN, TRANSPOSE, etc. shows that it is not a problem with the SHOW FORMULAS mode, but I will check the website link you provided

.

Answer 4

Hi PatriotO'Grady ,

I'm Mukesh and I will be happy to help you out with your question.

Can you share the errors for better understanding?

The most common reason for an Excel formula not calculating is that you have inadvertently activated the Show Formulas mode in a worksheet.

This guide will walk you through all possible causes and help you in identifying the issues. Excel formulas not working, not updating, not calculating: fixes & Solutions https://www.ablebits.com/office-addins-blog/2016/02/03/excel-formulas-not-working/

'Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.'

I hope this information helps. If you have any questions please let me know and I will be glad to help you out.

Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

Regards
Mukesh