Module-2 Chapter: 25- vLOOKUP Function

he VLOOKUP function in Excel is a powerful tool used for vertical lookup, which searches for a value in the first column of a table and returns a value in the same row from a specified column. Here’s a breakdown of how it works:
Imagine you have a table of employee IDs (column A) and names (column B), and you want to find the name of the employee with ID 12345.
=VLOOKUP(12345, A:B, 2, FALSE)

Пікірлер: 4

  • @riyaznadwi0607
    @riyaznadwi0607Ай бұрын

    Yet another useful formula

  • @TechMe.79
    @TechMe.79Ай бұрын

    Comment below if you find this lecture useful. Have you used vLOOKUP Function before.

  • @muhammadriyajuddin7073
    @muhammadriyajuddin7073Ай бұрын

    Great formula, n if there is possibility to add multiple column index number, please explain that area also

  • @TechMe.79

    @TechMe.79

    Ай бұрын

    A separate video on that will be made. We need to go chapter by chapter.