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
KuroDesu
Dec 13, 2021Copper Contributor
Hello Sergei, Thank you for this precisions:
The Version I use is Excel 2016 in Windows 10 (1607)
The logic I'm searching is:
I have a table of values that associate with certain users - eg If "RED" user "John"
After that I have an extract that I need to run through for this data
eg. the value color comes out in column "N" and I must assign user in column "S" but the assignment needs to respect the row
If "N1" the cell contains the word "RED" the cell "S1" needs to be populated with "John" .
The suggestion of Juliano, can I keep the matching row condition?
I've redone a new sample file
Hope this is more clear.
Thank you for you help and time
Juliano-Petrukio
Dec 13, 2021Bronze Contributor
- KuroDesuDec 13, 2021Copper ContributorThank you very much this does it perfectly