Forum Discussion
Solved
"if" and "index match" together
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 f...
You mention Sheet 2 and Sheet 3 but your formula refers to Sheet1 and Sheet2...
you are right, sheet one is where i am creating the formula but i a want to match it with information from sheet 2 and sheet 3.
i basically want to know if A=Name, than show me the quantity from sheet 2 based that it matches the same id otherwise show me quantity from sheet 3 based that the id matches, does this help?
=if(A1="Name", index(sheet2!B:B,MATCH(L2,Sheet2!M:M,0),INDEx(Sheet3!N:N,MATCH(L2,Sheet3!G:G,0))))
i basically want to know if A=Name, than show me the quantity from sheet 2 based that it matches the same id otherwise show me quantity from sheet 3 based that the id matches, does this help?
=if(A1="Name", index(sheet2!B:B,MATCH(L2,Sheet2!M:M,0),INDEx(Sheet3!N:N,MATCH(L2,Sheet3!G:G,0))))
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)
HansVogelaar 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