Quiz

1. 1
Intermediate

## Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,2,FALSE) return? 2. 2
Intermediate

## Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,1,FALSE) return? 3. 3
Intermediate

## Suppose cells A2:B20 contain a table with sorted product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,2) return?
{"ft_lang_label":"__label__en","ft_lang_prob":0.8689236,"math_prob":0.8930466,"size":1888,"snap":"2019-43-2019-47","text_gpt3_token_len":465,"char_repetition_ratio":0.23673037,"word_repetition_ratio":0.6769231,"special_character_ratio":0.23305085,"punctuation_ratio":0.07832898,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9657915,"pos_list":[0,1,2,3,4,5,6],"im_url_duplicate_count":[null,1,null,1,null,1,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2019-11-21T16:22:34Z\",\"WARC-Record-ID\":\"<urn:uuid:dec0d685-528d-4656-8c2b-7618de2f9f13>\",\"Content-Length\":\"37599\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:a5dbdda8-73a0-4d1f-81c9-ee870c461e2d>\",\"WARC-Concurrent-To\":\"<urn:uuid:3168ce8b-8871-42d8-a25e-337476b7887b>\",\"WARC-IP-Address\":\"168.61.22.107\",\"WARC-Target-URI\":\"https://www.goskills.com/Course/Excel/Lesson/23/VLOOKUP-with-Exact-Match/Quiz\",\"WARC-Payload-Digest\":\"sha1:2XJBA57BMJA4SMGOD3LP4D32LYPVOV2K\",\"WARC-Block-Digest\":\"sha1:BND6DTORB2U2CHLNTRDZU6L27GEGWYFR\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2019/CC-MAIN-2019-47/CC-MAIN-2019-47_segments_1573496670921.20_warc_CC-MAIN-20191121153204-20191121181204-00127.warc.gz\"}"}