May 13 2021 09:14 AM
Hi all,
I was wondering if someone could help me and point in the right direction.
Pretty new to excel and specifically using multiple formulas.
I am trying to use If and Index match in the same formula but doesn't want to work.
so i have 3 different tables in 3 different sheets.
the idea is that if cell A= "specific name" then I need to use an index match from sheet 2, otherwise I need to use index match from sheet 3.
what i did:
=if(A="Name", index(sheet1!B:B,MATCH(L2,Sheet1!M:M,0),INDEx(Sheet2!N:N,MATCH(L2,Sheet2!G:G,0))))
thank you very much for help!
May 13 2021 09:37 AM
You mention Sheet 2 and Sheet 3 but your formula refers to Sheet1 and Sheet2...
May 13 2021 09:50 AM
May 13 2021 09:56 AM
It should be
=IF(A1="Name", INDEX(Sheet2!B:B, MATCH(L2,Sheet2!M:M,0)), INDEX(Sheet3!N:N, MATCH(L2,Sheet3!G:G,0)))
(I moved one closing parenthesis)
May 13 2021 10:09 AM
@Hans Vogelaar it doesn't want to work(
i attached screens maybe this will be more clear what i am trying to do. Link with the workbook and pictures. thanks so much for helping me out!
https://1drv.ms/x/s!AgSn2Fjy1lHAd-Kv73z7vVIF3i4?e=G5L5oA
May 13 2021 10:30 AM
SolutionMay 13 2021 10:30 AM
SolutionYou missed a comma and a closing parenthesis.
See the attached version.