Jun 02 2022 02:16 AM
Dear all,
Can someone help me with my formula?
=INDEX('[COSTED_BOM_RFQ_REDUCED__FULL_SMART_LCU_20220523 (1).xlsx]Sheet0'!K11:K93;MATCH(C8;'[COSTED_BOM_RFQ_REDUCED__FULL_SMART_LCU_20220523 (1).xlsx]Sheet0'!B11:B93;0);11)
Thanks in advance,
Caro
Jun 02 2022 02:26 AM
SolutionHi @Caro_Bloggs
the first part of your INDEX formula refers to just one column (K11:K93), but with the very last argument you refer to colum 11.
So if you want to return the value of column 11, the INDEX range should at least cover K11:U93
Jun 02 2022 02:28 AM
The 11 as last argument of INDEX tells Excel to look in the 11th column f K11:K93, but that range has only 1 column. Remove that argument:
=INDEX('[COSTED_BOM_RFQ_REDUCED__FULL_SMART_LCU_20220523 (1).xlsx]Sheet0'!K11:K93;MATCH(C8;'[COSTED_BOM_RFQ_REDUCED__FULL_SMART_LCU_20220523 (1).xlsx]Sheet0'!B11:B93;0))
Jun 02 2022 02:38 AM
Jun 02 2022 02:26 AM
SolutionHi @Caro_Bloggs
the first part of your INDEX formula refers to just one column (K11:K93), but with the very last argument you refer to colum 11.
So if you want to return the value of column 11, the INDEX range should at least cover K11:U93