Forum Discussion
KuroDesu
Dec 10, 2021Copper Contributor
More then 64 levels of nesting need a simpler formula
Hello All, I'm new to excel and just bumped into the max nesting . Can anyone please help me to simplify the formula or help me find a way around it please? I need the IF Formula to run a search...
- Dec 13, 2021
Juliano-Petrukio
Dec 10, 2021Bronze Contributor
What about:
=INDEX(ColumnContainingDesiredValues,
MATCH(YourCriteria,ColumnContainingDataAsPerYourCriteria,0),1)