Where Are The Matching Cells? - Duel 194

У вашего броузера проблема в совместимости с HTML5

You have two lists of data in Excel. If something from List2 is found in List1, put the address of the matching cell next to the item in List2. Mike and Bill try to find a one-cell formula using either CELL or ADDRESS in this week’s episode.

Table of Contents
(0:00) Description of problem
(0:30) Does ADDRESS or CELL return a spillable array?
(2:02) Can XLOOKUP return an array of references?
(3:33) Bill’s answer: a single ADDRESS formula that spills
(5:47) Mike’s first answer: using old-school CELL function and copying
(8:07) Mike’s second answer: using LET and XLOOKUP
(10:05) Wrap-up