@jasgot said in Excel Help:
@hobbit666 said in Excel Help:
Desktop1 Microsoft Windows 10 Pro 10.0.19041
Desktop2 Microsoft Windows 10 Pro 10.0.19042
Desktop3 Microsoft Windows 10 Pro 10.0.18363
Desktop4 Microsoft Windows 10 Pro 10.0.19041
Desktop5 Microsoft Windows 10 Pro 10.0.19041
Desktop6 Microsoft Windows 10 Pro 10.0.19041
Desktop7 Microsoft Windows 10 Pro 10.0.19042
No Need for a bunch of Nested IF= statements.
VLOOKUP is made for this. Although XLOOKUP is the new VLookup.
Here's the formula in Column I of my screen shot. Don't worry about the $, they just mean the formula should not auto advance when you copy and paste to other cells.
=VLOOKUP(H4,$C$21:$D$25,2,FALSE)
The "False" means EXACT Match, please leave it as False.

Mostly correct, except he doe snot have the version split into it's own column.
He only has A and B as noted.
@hobbit666 said in Excel Help:
A | B
Desktop1 Microsoft Windows 10 Pro 10.0.19041
So it would be more like this, assuming that the data starts in row 2 and the lookup table starts on Row 21
=VLOOKUP(RIGHT(B2,10),$A$21:$B$25,2,FALSE)