![]() ![]() ![]() ![]() This differs from our first formula in that it includes a number of cells in the first row. ![]() Setting the table_array to B1:E13 ensures that Excel will look in the area that contains the sales numbers. This tells Excel that we’re looking for a column with “05-16-17” in the first cell. For this task, we’ll add “05-16-17” as this parameter. Let’s try looking up a date that’s not listed in one of the columns.Īgain, we’ll start with the lookup_value. On the second sheet in the example file is a list of salespeople from the first sheet and their sales numbers for a range of specific dates.Įach of those dates corresponds to the number of sales an employee has made by that day. Let’s use range_lookup to spice it up a bit. This, as you might expect, simply returns the 14th value down in the Full name column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |