Since pre-2019 versions of Excel don't support XLOOKUP, don't discard VLOOKUP and HLOOKUP altogether! There may still be cases when you need to use them, like if you're sending a spreadsheet to ...

Also, if your sheet name changes ... This time, we will use named references so that we can use INDIRECT with Excel's VLOOKUP function. We want Excel to tell us how much money each of the four ...