VLOOKUP Function (Vertical Lookup)
The VLOOKUP function in Microsoft Excel is used to search for a value in the first column of a table and return a corresponding value from another column in the same row. The “V” stands for vertical, meaning it works down columns.
The syntax of the VLOOKUP function is:
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
- lookup_value: The value you want to search for.
- table_array: The range of cells containing the data.
- col_index_num: The column number from which to return the value.
- range_lookup: Optional; TRUE for approximate match or FALSE for exact match.
For example, if you have a table with student names in the first column and their marks in the second column, VLOOKUP can quickly find a student’s marks by searching their name.
VLOOKUP is widely used for tasks like finding prices, retrieving employee details, or matching data between sheets. However, it only searches from left to right and requires the lookup value to be in the first column.
Although newer functions like INDEX and MATCH or XLOOKUP are more flexible, VLOOKUP remains one of the most popular and easy-to-use lookup functions in Excel.
VLOOKUP Function (ଓଡିଆରେ ବ୍ୟାଖ୍ୟା )
VLOOKUP function Microsoft Excel ରେ ଏକ ବହୁତ ପ୍ରଚଳିତ function ଅଟେ, ଯାହା ଦ୍ୱାରା କୌଣସି value କୁ ଟେବୁଲର ପ୍ରଥମ column (ସ୍ତମ୍ଭ) ଭିତରେ ଖୋଜି, ସେହି row ର ଅନ୍ୟ column ରୁ ସମ୍ବନ୍ଧିତ value ଫେରାଇ ଦିଏ। “V” ର ଅର୍ଥ ହେଉଛି Vertical, ଅର୍ଥାତ ଏହା column ଆଧାରିତ ଭାବରେ କାମ କରେ।
VLOOKUP ର syntax ହେଉଛି:
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
- lookup_value: ଯେ value କୁ ଖୋଜିବେ
- table_array: ଡାଟା ଥିବା range
- col_index_num: କେଉଁ column ରୁ value ନେବେ
- range_lookup: optional (FALSE → exact match, TRUE → approximate match)
ଉଦାହରଣ ସ୍ୱରୂପ, ଯଦି ପ୍ରଥମ column ରେ student ନାମ ଓ ଦ୍ୱିତୀୟ column ରେ marks ରହିଛି, ତେବେ VLOOKUP ଦ୍ୱାରା ନାମ ଦେଇ marks ସହଜରେ ଖୋଜିପାରିବେ।
VLOOKUP ବ୍ୟବହାର କରାଯାଏ data search, report ତିଆରି, employee details କିମ୍ବା price list ଖୋଜିବା ପାଇଁ। କିନ୍ତୁ ଏହା କେବଳ left-to-right କାମ କରେ।
ନୂତନ Excel ରେ INDEX, MATCH ଓ XLOOKUP ଅଧିକ advanced ହେଲେ ମଧ୍ୟ, VLOOKUP ସରଳ ଓ ଅତ୍ୟନ୍ତ ଉପଯୋଗୀ function ଭାବେ ରହିଛି।
