Absolutely you can!
The below video is a good tutorial on how to do a simple VLOOKUP between sheets. The video steps you through the different components of the formula and how to put them together (the quick way).
VLOOKUP Different Sheet Tutorial
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.