@jasgot said in Excel Help:
No Need for a bunch of Nested IF= statements.
VLOOKUP is made for this. Although XLOOKUP is the new VLookup.
I did already mention LOOKUP in a couple of posts above.
But the power of the IFS is really when you just have a few different options and put them directly in the formula. Then you don't need a lookup table at all.
The SWITCH makes it even better as that is the equivalent to a case statement.
=SWITCH(F2, "10.0.19043", "21H1", "10.0.19042", "20H2", "10.0.19041", "2004", "10.0.18363", "1909", "10.0.17763", "1809", "OLD!")