Miercuri, 20.06.2018, 08:24:09
Bine aţi venit Vizitator | Înregistrare | Autentificare

VIO

Meniu site
Categoriile secţiunii
    
    
    
    
    
    
    
    
    
    
CALENDAR
Vremea
Prietenii site-ului
Stiri
Statistici

Total online: 1
Vizitatori: 1
Utilizatori: 0
Categoriile canalului

Video

Principală » Video » Tutoriale_video_EXCEL

Excel - How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX

00:15:54
Vizualizări: 0 Adăugat de: vio vio 
Descrierea intrării:

When you need to find and extract a column of data from one table and place it in another, use the VLOOKUP function. This function works in any version of Excel in Windows and Mac, and also in Google Sheets. It allows you to find data in one table using some identifier it has in common with another table. The two tables can be on different sheets or even on different workbooks. There is also an HLOOKUP function, which does the same thing, but with data arranged horizontally, across rows.See the companion tutorial on Tuts+ at https://computers.tutsplus.com/tutorials/how-to-extract-data-from-a-spreadsheet-using-vlookup-match-and-index--cms-20641.By Bob Flisser.

Limba: Rusă
Timpul de rulare al video-ului: 00:15:54
Autor: Tuts+ Computer Skills
Total comentarii : 0
Doar utilizatorii înregistraţi pot adăuga comentarii
[ Înregistrare | Autentificare ]