Download Excel File: http://excelisfun.net/files/MrExcelExcelisfunTrick194.xlsx
How to compare two lists and if item from List #2 in in List #1, lookup and deliver cell address. See Bill Mr Excel Jelen and Mike excelisfun Girvin show multiple cans to accomplish this task. Learn about the Worksheet Functions: ADDRESS, ROW, COLUMN, INDEX, MATCH, XLOOKUP, LET, IF, ISNA, XMATCH, IFNA, and SUBSTITUTE.
Topics:
1. (00:00) Duel Song.
2. (00:32)Introduction.
3. (01:02) Mr Excel Formula #1.
4. (05:59) excelisfun Formula #2.
5. (08:39) excelisfun Formula #3.
6. (10:40) Mr Excel concludes.
7. (11:13) End Duel Song