![\"\"](\"https:\/\/sapsecurityanalyst.com\/WP\/wp-content\/uploads\/2014\/03\/img_531bfd715c296.png\")
<\/p>\n
lookup _value:\u00a0<\/b>The\u00a0value\u00a0we want to find in the first\u00a0column\u00a0of the\u00a0table_array.<\/p>\n
table_array:\u00a0<\/b>This is the table of\u00a0data\u00a0that VLOOKUP searches to find the information we are looking for.<\/span><\/p>\n col_index_num:<\/b>\u00a0The column number in the table_array that contains the data we want returned.<\/p>\n range_lookup:<\/b>\u00a0A logical value (TRUE or FALSE only) that indicates whether we want VLOOKUP to find an exact or an approximate match to the lookup_value. Typing\u00a0False\u00a0<\/i>will return exact matches only.<\/p>\n <\/p>\n Let’s see how it actually works.<\/p>\n Below are the two lists in excel:<\/p>\n Let’s do a VLOOKUP to find this. We can either directly write the formula for VLOOKUP (as shown below) or we can use the function field (fx<\/em>) to insert the function for vlookup using vlookup window:<\/p>\n Let’s do the vlookup for finding those values which are in List A in the List B. We will try it using the vlookup function argument (Option 2 above).<\/p>\n Click on cell C2 and execute function vlookup to get the vlookup window. The first value in List A is user 1 which is in cell A2. Since this needs to be searched first, we will insert A2 in lookup_value.<\/p>\n Since value user 1 can be present in any of the cells in List B, we need to select the whole column B. As soon as column B is selected, the value in the text box Table_array automatically gets updated with B:B.<\/p>\n Finally insert value False<\/strong> in Range_lookup text box (since we are searching for the exact value)<\/p>\n <\/p>\n \n","protected":false},"excerpt":{"rendered":" In this post, we are going to discuss about VLOOKUP in Microsoft Excel. The “V” in VLOOKUP stands for vertical. It is a very important function which can be used for finding data from sets of data which are in one or more columns. …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/sapsecurityanalyst.com\/WP\/wp-json\/wp\/v2\/pages\/1848"}],"collection":[{"href":"https:\/\/sapsecurityanalyst.com\/WP\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sapsecurityanalyst.com\/WP\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sapsecurityanalyst.com\/WP\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sapsecurityanalyst.com\/WP\/wp-json\/wp\/v2\/comments?post=1848"}],"version-history":[{"count":3,"href":"https:\/\/sapsecurityanalyst.com\/WP\/wp-json\/wp\/v2\/pages\/1848\/revisions"}],"predecessor-version":[{"id":1865,"href":"https:\/\/sapsecurityanalyst.com\/WP\/wp-json\/wp\/v2\/pages\/1848\/revisions\/1865"}],"wp:attachment":[{"href":"https:\/\/sapsecurityanalyst.com\/WP\/wp-json\/wp\/v2\/media?parent=1848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
![\"\"](\"https:\/\/sapsecurityanalyst.com\/WP\/wp-content\/uploads\/2014\/03\/img_531c0a55bdc81.png\")
<\/p>\n![\"\"](\"https:\/\/sapsecurityanalyst.com\/WP\/wp-content\/uploads\/2014\/03\/img_531c20d18518b.png\")
<\/p>\n![\"\"](\"https:\/\/sapsecurityanalyst.com\/WP\/wp-content\/uploads\/2014\/03\/img_531c29d162a97.png\")
Now place the cursor on Table_array text box in vlookup window.<\/p>\n![\"\"](\"https:\/\/sapsecurityanalyst.com\/WP\/wp-content\/uploads\/2014\/03\/img_531c2ad3bcf98.png\")
Now place the cursor in the text box for Col_index_num. Since column B is the only column where we are trying to find data, insert 1 in this text box.<\/p>\n![\"\"](\"https:\/\/sapsecurityanalyst.com\/WP\/wp-content\/uploads\/2014\/03\/img_531c2c3023016.png\")
Click OK.<\/p>\n![\"\"](\"https:\/\/sapsecurityanalyst.com\/WP\/wp-content\/uploads\/2014\/03\/img_531c2c9de0356.png\")
We got #N\/A<\/strong> in cell C2 which suggests that value user 1 is not present in List B. Now click on bottom right corner of cell C2 to get the following:<\/p>\n![\"\"](\"https:\/\/sapsecurityanalyst.com\/WP\/wp-content\/uploads\/2014\/03\/img_531c2dcb17fab.png\")
This screen shows that values user 2, user 3 and user 5 are present in List B.<\/p>\n