Microsoft Office Tutorials and References
In Depth Information
Using COLUMN to Assist with VLOOKUP When Filling a Wide Table
If you study the data in Figure 12.24 , you will see that three more
names are in the column C list than in the column A list, yet four
people were reported as being new this week. This means that one of
the people from last week has dropped off the list. To quickly find
who dropped off the list, use the formula
=VLOOKUP(A3,$C$3:$C$18,1,FALSE) in B3:B15 to find that Donald
Tyler has dropped off the list.
Note that you can also use MATCH to solve this problem.
When Filling a Wide Table
This section discusses some special considerations to keep in mind when you
have to retrieve many columns from a table. If you think carefully about
the first formula, you can quickly copy it to the entire table.
Figure 12.25 shows a table of several hundred SKUs, starting in row 21. For
each SKU, the table contains the inventory of that product on hand in the
12 regional warehouses. Range A6:B13 contains a customer order for various
SKUs. You want to build a table to help visualize which warehouse has most
of the items in stock. If you find one warehouse that has all the inventory,
you can minimize order shipping costs by shipping the entire order from that
particular warehouse.
COLUMN to Assist with
to Assist with VLOOKUP
VLOOKUP When Filling a Wide Table
Search JabSto ::

Custom Search