VLookUp ද XLookUp ද- දෙකම ඉගෙන ගනිමු

VLOOKUP and XLOOKUP are both functions in Microsoft Excel that can be used to look up and retrieve data from a table or range of cells. The main difference between the two functions is that VLOOKUP is an older function that has been available in Excel for many years, while XLOOKUP is a newer function that was introduced in Excel 365 in 2020.
XLOOKUP works similarly to VLOOKUP, but it has a more flexible syntax and additional options for specifying the range to be searched, the column from which to return the value, and the order in which to sort the data.