Excel's VLOOKUP function is valuable when you export reports from, for example, Microsoft Intune in CSV format.
Often, you need to combine data from other systems, and then VLOOKUP comes in and saves the day :)
In this video, we show an example of a Microsoft Intune report data gets added to another report with the help of VLOOKUP.
You don't need any previous experience with Excel functions/formulas; we go through the steps.
Timeline
00:00:00 Intro
00:00:37 Scenario
00:01:15 Export to CSV from Intune
00:02:34 Work with the data in Excel
00:03:58 VLOOKUP!
00:10:00 Outro
Негізгі бет Learn Excel VLOOKUP function to display data from multiple reports
Пікірлер: 6