Did you know that you can use a VLOOKUP to get a value from a table in another workbook?
This video tutorial demonstrates just that – how to do a VLOOKUP using the builder (Insert Function) across two workbooks.
There is a quicker way too (just typing the formula) but the way shown in this tutorial is a good starting point.
VLOOKUP YouTube: VLOOKUP using the builder
Want to get good at using the VLOOKUP function?
Download our practical VLOOKUP tutorial workbook with step-by-step instructions and examples to help you become a VLOOKUP pro.