VLOOKUP 和 HLOOKUP_表哥网_百度空间(国外英语资料).docVIP

VLOOKUP 和 HLOOKUP_表哥网_百度空间(国外英语资料) VLOOKUP and HLOOKUP_ network _ cousin Baidu space My personal homepage friend message center (59) add friends (2) comments (0) notification system (0) news station (57) xel7000| | dress set | exit My cousin introduced network functions and modules of Excel applications, and the use of Excel tips page blog album | personal files | friends see article VLOOKUP and HLOOKUP2010-06-23, in addition to using Excel to do reports and calculations at 18:23, many people use Excel Make lists and even Mini databases. Finding functions is important at this point. VLOOKUP is more commonly used, and it is also worth learning a search function. VLOOKUP use: VLOOKUP in the list (or array) first find a value, and returns the specified value of a column in the row. VLOOKUP syntax: VLOOKUP (lookup values, list ranges, column numbers, matching methods) Lookup values are values that need to be found in the first column of a list (or array). The list range refers to the range of the list, or you can enter the array directly. Column number refers to the number of data that needs to be returned in the list (or array). Note that the column ordinal is the number of columns corresponding to the range of the list. It must be greater than or equal to 1, less than the number of columns in the list. The matching method can be exact matching or approximate matching. TRUE, 1 or no, represents approximate matches; FALSE or 0 represent exact matches. If the selection matches approximately, the first column of the list must be sorted from small to large, and returns the maximum value less than or equal to the lookup value. For example, in 1, 2, 3, find 2, return 2; in 1, 3 in search 2, return 1. VLOOKUP example: ABC 1 number name results 21000David70 31005Mary30 41011John50 51011Jane60 61020Peter80 Seven Eighty-one thousand Interpretation of formula results =VLOOKUP (1005, $A$2:$C$6,2) Mary, in the range of $A$2:$C$6, finds the first column is less than or equal to the