How to use VLOOKUP formula to make reports on Excel

preview_player
Показать описание
Short tutorial on how to use VLOOKUP formula to make reports using data from different sheets but with a common value. For ADVETI,, this is helpful for effective student reports on results by combining attendance, EmSAT, phone numbers, etc.

Formula: =VLOOKUP(common value, table with data needed, column number, FALSE)
Рекомендации по теме