Forum Discussion
IF statement more than 64; Macro?
Hello thanks for taking a moment to try to help me. I am working on a spreadsheets that I am hoping to simplify. What I am looking for is a function that will read a cell and then imput a v...
You can apply INDEX / MATCH or VLOOKUP. If you work with Excel 2016 or later you can apply XLOOKUP. All options are much easier to set up and to maintain compared to nested IF (or IFS) statements.
- Agreed.
