Need help with complex formula
Hello All,
I need help with formula.
Here is the example what I want to achieve
=IF A2=Sheet5!C4 and D2="M" than F2*Sheet5!E4
But I need insert more conditions. Like, if D2 will be S (instead of M) than F2*Sheet5!E6 and if D2 will be N than F2*Sheet5!E7 and etc.
Last edited by levaxuco; 05-11-2021 at 08:58 AM.
How aboutFormula:
Please Login or Register to view this content.
Thanks a lot!
You're welcome & thanks for the feedback.
just one more thing... on the sheet2 there are two different ID's. According to them I need to calculate different %.
For example. if A2=Sheet2!C10 (and C10 has different ID) it should make different calculation.
I have updated attached file.
Thanks in advanced.
You really helping me
in this case this should work right? => =IF(A2=Sheet2!C4,INDEX(Sheet2!E4:E7,MATCH(D2,Sheet2!D4:D7,0))*F2,IF(A2=Sheet2!C10,INDEX(Sheet2!E10:E13,MATCH(D2,Sheet2!D10:D13,0))*F2,))
Looks good, have you tried it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks