7 - VLOOKUP Function in Excel | Excel Advanced Tutorials | Sinhala | IT Plus

Unlock the full potential of Excel with our comprehensive guide on the VLOOKUP function. Learn how to efficiently search and retrieve data, create dynamic spreadsheets, and streamline your workflow. Whether you're a beginner or an experienced user, this tutorial covers everything you need to know about mastering VLOOKUP in Excel.
VLOOKUP function,
Excel VLOOKUP tutorial,
How to use VLOOKUP in Excel,
Excel data retrieval,
VLOOKUP examples,
Excel formula guide,
Advanced Excel functions,
Spreadsheet data lookup,
Excel data analysis,
Microsoft Excel tips,
Advanced Excel Tutorials,
Advanced Excel Tutorials sinhala,
VLOOKUP Function with examples,
IT Plus,
Advanced Excel Tips,

[@lalithfernando9779]

Hi Chaminda
I went through your advanced tutorials up to 11 and gained a considerable knowledge starting from "zero"
In this VLOOKUP lesson, I have a problem in example 1.As you said in the video, I entered the "lookup vales" as the first name of the "NAME" column. Then made the array table values "ABSOLUTE". This did not work.
Then, I again started with the VLOOKUP function and this time I selected the whole "NAME" column (Earlier only the first name was selected) of the main table. This time I straight a way got the required answers under the column "COURSE" of the main table. There was no need to make array table values "ABSOLUTE)
I shall be thank full if you kindly explain the reason for this
Rgds
Lalith

[@itplus4042]

i will give new viedo for your problem