Microsoft Office Tutorials and References
In Depth Information
Using COLUMN to Assist with VLOOKUP When Filling a Wide Table
Figure 12.25.
Figure 12.25. The
The COLUMN
COLUMN function in row 4 ensures that you can enter the
function in row 4 ensures that you can enter the
VLOOKUP
VLOOKUP formula once and copy it to the entire rectangular range.
formula once and copy it to the entire rectangular range.
To solve this problem, follow these steps:
11. Copy the range of warehouse names from B20:M20 to C5:N5.
22. Think about the third argument in the VLOOKUP function. For the for-
mula in column C, you want to return the second column from the
table. For the formula in column D, you want to return the third
column. If you actually enter the 2 in the formula in column C, then
Search JabSto ::




Custom Search