Forum Discussion

Copper Contributor

Jul 06, 2019

Solved

INDEX MATCH column limit

i am a newbie and searched for answer but did not see it - so I appreciate assistance... I am doing a index match function - but I believe I am running into a limit in the column lookup to get my an...

excel

Formulas and Functions

Detlef_Lewin
Jul 06, 2019
gogglespasaino
Your matrix is from column A to column CZ which correspond to columns 1 to 104.
The formula part which calculates the column is COLUMN(DA1) which corresponds to column 105.
Can you spot the problem?

Detlef_Lewin

Silver Contributor

Jul 06, 2019

gogglespasaino

Your matrix is from column A to column CZ which correspond to columns 1 to 104.

The formula part which calculates the column is COLUMN(DA1) which corresponds to column 105.

Can you spot the problem?

gogglespasaino

Copper Contributor

Jul 06, 2019

Detlef_Lewin

THANK YOU so much - I cannot believe I missed that - after looking at it for about 2 hours !!! - LOL...

I have the same formula on multiple tabs...and the data on those arrays goes to CJ - so I thought CZ would have been fine (when I BLINDLY copies and pasted the formula) - not even realizing the data on the array that I am currently working on goes to column "HV"...AGAIN VERY MUCH APPRECIATED - my stress level as been reduced - all the best !!!!!