![\"Post1499\"](\"http:\/\/xlfxs.com\/wp-content\/uploads\/2016\/05\/Post1499.jpg\")
<\/a><\/p>\nThe Green <\/span>box (Lookup_Value) is what the function will search for, and the vertical green box is where, this is because we selected the range (Table_Array) in Blue as the area of D:G, so VLookup will search in D, this is the V part in VLOOKUP, we should also expect to see HLookup<\/a>. <\/p>\n The Red number (COl_Index_Num) is the number of column we need to have result from, again, because we selected D:G, if we types 1 in Col_Index_Num, we will get what is in column D that matches the same row where we found “Mar”.<\/p>\n In this case “Mar”<\/p>\n <\/p>\n While the “Range_Lookup” is something related to the type of search, we just did “False” to make sure it searches for the exact match. to read more about “Range_Lookup”, please\u00a0check the ‘Help’ section in Excel<\/p>\n The idea is to get result from column other than 1, this is why we are doing the search right?<\/p>\n So our function will be<\/p>\n Sample:<\/p>\n And the result is as we expected.<\/p>\n <\/p>\n Other ways to do Vlookup is using INDEX + MATCH<\/a> or OFFSET + MATCH<\/a><\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" I have been asked for a while now to just put a simple VLookup function, here it is, I know this might be stupid to post it here, but we need to fill requests from all types of visitors. Vlookup is the most famous function in Excel, some people actually refer to Excel as VLookup….<\/p>\n
\nMeans if item is not found in column D, VLookup will return as #N\/A error<\/p>\n<\/a><\/p>\n=VLOOKUP(\"Mar\", D:G, 4, False)<\/pre>\n
<\/a><\/p>\n