# 补上这3招Excel查询技巧，碾压众多装B”高手”

=HLOOKUP(查找值，查找区域，返回第几行的数据，精准查找或近似查找)

1、根据门店查询指定产品的销售额 2、根据销售额查找对应奖金 =HLOOKUP(\$G2,\$B\$2:\$E\$3,2)，往下填充即可（这里省略最后一个参数，采用的是近似查找）

3、合并多张表格数据

=IFERROR(HLOOKUP(A\$1,一年级!\$A\$1:\$D\$11,ROW(A2),0),"") =IFERROR(HLOOKUP(A\$1,二年级!\$A\$1:\$D\$12,ROW(A2),0),"") =IFERROR(HLOOKUP(A\$1,三年级!\$A\$1:\$D\$5,ROW(A2),0),"")
{"ft_lang_label":"__label__zh","ft_lang_prob":0.9517493,"math_prob":0.9998416,"size":828,"snap":"2021-21-2021-25","text_gpt3_token_len":723,"char_repetition_ratio":0.13470873,"word_repetition_ratio":0.0,"special_character_ratio":0.2669082,"punctuation_ratio":0.18115942,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9558324,"pos_list":[0,1,2,3,4,5,6,7,8,9,10],"im_url_duplicate_count":[null,1,null,1,null,1,null,1,null,1,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2021-05-19T00:24:01Z\",\"WARC-Record-ID\":\"<urn:uuid:57875d46-549d-4984-9e8b-2a9fe3f58a65>\",\"Content-Length\":\"42942\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:24b13d96-d510-4046-a514-52ebb5c30a6c>\",\"WARC-Concurrent-To\":\"<urn:uuid:556318a3-8254-436a-8ce3-de92fcfa9ba7>\",\"WARC-IP-Address\":\"39.98.72.2\",\"WARC-Target-URI\":\"https://ydiant.com/p/15775980841611.html\",\"WARC-Payload-Digest\":\"sha1:46NGWXD42L5OUUBEG25NUFNMYCRCGF3Y\",\"WARC-Block-Digest\":\"sha1:3C4A3UKVHR2A2OXUE3KEXCWJVM7W67CI\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2021/CC-MAIN-2021-21/CC-MAIN-2021-21_segments_1620243989874.84_warc_CC-MAIN-20210518222121-20210519012121-00310.warc.gz\"}"}