Monicasinha
Board Regular
- Joined
- Dec 26, 2022
- Messages
- 51
- Office Version
- 365
- Platform
- Windows
I am working in a heavy VBA and complex formula workbook. Index formula doesnt seem to be working. I am using the formula
=INDEX('Sheet1'!G417:AD516,MATCH(CONCATENATE(J5,E12,F12),'Sheet1'!A417:A516,0),MATCH(J11,'Sheet1'!G416:AD416,0)).
Result is 0.
The value however should be "JON".
On evaluating, it shows: =INDEX('Sheet1'!G417:AD516,1,1).
It is referencing to the correct cell only.
If I just put the formula =INDEX('Sheet1'!G417:AD516,1,1), it gives me the value "JON". But not through =INDEX('Sheet1'!G417:AD516,MATCH(CONCATENATE(J5,E12,F12),'Sheet1'!A417:A516,0),MATCH(J11,'Sheet1'!G416:AD416,0)).
Pls help
=INDEX('Sheet1'!G417:AD516,MATCH(CONCATENATE(J5,E12,F12),'Sheet1'!A417:A516,0),MATCH(J11,'Sheet1'!G416:AD416,0)).
Result is 0.
The value however should be "JON".
On evaluating, it shows: =INDEX('Sheet1'!G417:AD516,1,1).
It is referencing to the correct cell only.
If I just put the formula =INDEX('Sheet1'!G417:AD516,1,1), it gives me the value "JON". But not through =INDEX('Sheet1'!G417:AD516,MATCH(CONCATENATE(J5,E12,F12),'Sheet1'!A417:A516,0),MATCH(J11,'Sheet1'!G416:AD416,0)).
Pls help