From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Tabulating totals with the VLOOKUP function and array constants

Tabulating totals with the VLOOKUP function and array constants - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Tabulating totals with the VLOOKUP function and array constants

“

- [Instructor] Excel's VLOOKUP functions is one 2 of the most powerful and widely-used functions in Excel. 3 It's also considered one of the more important ones too. 4 At least one Excel author has made the statement, 5 may be provocative, 6 "It's the most important function in Excel." 7 Well, whether it is or isn't, we want to use it here, 8 but perhaps in a way you have not seen. 9 We've got a big list here, 10 and it's going to grow and grow and grow. 11 These are salespersons in different offices 12 around the country. 13 They sell, imagine, property, 14 so they don't have that many sales every year. 15 And from time to time, we want to check 16 on this person or that person. 17 We might eventually have a pick list, 18 maybe in column J, and have a list of names, 19 pick one out of there, as we're looking 20 for different data about that person. 21 So I'll just copy a name over there. 22 Here's Walter White in…

Contents