Excel VLOOKUP: Basics of VLOOKUP explained with examples in Tamil #MsExcel #vlookup #tamilexcel

எப்படி Vlookup போடலாம் வாங்க பார்க்கலாம்.

Find out how to do a VLOOKUP in Excel.

“V” in VLOOKUP refers to vertical and “H” in HLOOKUP refers to horizontal. If the data in your table has column headers, use the VLOOKUP function. If the data table has row headers and you need to search horizontally across the rows for a “match” then use HLOOKUP formula.

Vlookup formulas do not need to have sorted lists. If your Excel table is unsorted make sure you look for an exact match by selecting "false" in the last argument of Vlookup.

One major limitation of VLOOKUP is that it cannot look to the left. The values to lookup must always be on the left-most column of the range and the values to return must be on the right hand side.

Let’s connect on social:

#MsExcel

[skHibiscus]

Little I understand better but a big request, formula you didn't explain fully. Formula explanation with comma, dollar are very important in excel working. Pls explain the formula