How to Use =VLOOKUP Formula for Non-Inventory Payables Invoice Register
Amber Schmitz
|
11 steps
|
21 seconds
1
Highlight the column next to the "Supplier"
2
Click "Insert"
3
Click cell B1
4
Type "APC [[enter]]"
5
Type "=VLOOKUP(,"
6
Select cell A2 to tell the formula to look for the "Supplier" in the Work Assignments worksheet.
7
Highlight the column that contains the Supplier name by selecting the column's header. (In this case, Column A).
8
Drag your mouse across the columns until you reach the APC name. Type ",7,FALSE) [[enter]]". This will return the APC information to the Invoice Register.
9
Click "B2"
10
Double click the bottom right hand corner of cell "B2" to carry the formula down to the rest of the cells
11
Add a filter to your Invoice Register and filter for your name.
