We'll also explore VLOOKUP, HLOOKUP ... such as "TV," you can use this formula: =LOOKUP("TV", A2:C5) This function first will ...

An curved arrow pointing right. VLOOKUP is one of the most useful functions in Excel. You can pull specific data out of huge data sets with a simple formula. Just watch. Produced by Sara ...

So, adding to our formula means that Excel will create ... 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 ...