MS Excel - Vlookup in Excel Video Tutorial || easy learning tutorials

Опубликовано: 22 Октябрь 2024
на канале: Easy Learning Tutorials
78
8

When you need to find something in a table or a range by row, use VLOOKUP.  
eg.
Check up the pricing of an automotive part using the part number, or look up an employee's name using their employee ID.
The VLOOKUP function, in its most basic form, says:

=VLOOKUP(What you want to look up, where you want to look it up, the column number in the range holding the value you wish to return, return an Approximate or Exact match – denoted as 1/TRUE, or 0/FALSE)

#exceltips #vlookup #excel #learnexcel #microsoftexcel #tipsandtricks @easylearningtutorials #learntips #easy