filmov
tv
How to use VLOOKUP formula to make reports on Excel

Показать описание
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)
Formula: =VLOOKUP(common value, table with data needed, column number, FALSE)