Forum Discussion
Solved
** Need help with Formula **
Hi All, I need help writing a formula based on IF hypotheticals for instance, the value the below field will always change but will always start with one of the following as, me and ma Switch: ...
Try
=INDEX($G$18:$G$32, MATCH(1, ($D$18:$D$32=LEFT(I24,2))*($E$18:$E$32=J24)*($F$18:$F$32=K24), 0))
As mentioned before, if you do not have Microsoft 365 or Office 2021, but an older version, confirm the formula by pressing Ctrl+Shift+Enter.
Thanks for your help, i have tried to do the following as mentioned but i cant seem to get it right, please see screenshot below, as mentioned the switch(es) could be a combination of as, me or ma followed by a string of letters after as given I25 but will always start as as, me or ma. the idea is that based on the switch, interface type and access mode, i need it to populate the optic code.
Let me know what im doing wrong 🙂
Thanks once again 🙂
Try
=INDEX($G$18:$G$32, MATCH(1, ($D$18:$D$32=LEFT(I24,2))*($E$18:$E$32=J24)*($F$18:$F$32=K24), 0))
As mentioned before, if you do not have Microsoft 365 or Office 2021, but an older version, confirm the formula by pressing Ctrl+Shift+Enter.
- Thanks Hans, that worked a treat although I had to remove the a-end access mode but that isn't significant in this case. I truly appreciate your help!