exceltips99 (@exceltips99) 在 Piclur：My version — I prefer the classical INDEX+MATCH+MATCH approach, which works in Excel 2021 and earlier, rather than XLOOKUP+XLOOKUP. I find the formula easier to read. / Piclur

exceltips99

年10月29日

My version — I prefer the classical INDEX+MATCH+MATCH approach, which works in Excel 2021 and earlier, rather than XLOOKUP+XLOOKUP. I find the formula easier to read.

exceltips99's tweet image. My version — I prefer the classical INDEX+MATCH+MATCH approach, which works in Excel 2021 and earlier, rather than XLOOKUP+XLOOKUP. I find the formula easier to read.

此推文已無法使用。

United States 趨勢

1. Dolphins 20.2K posts
2. Ravens 33.2K posts
3. #911onABC 12.3K posts
4. Lamar 37.1K posts
5. Mark Andrews 2,372 posts
6. Ollie Gordon 1,164 posts
7. Mike McDaniel N/A
8. Athena 12.6K posts
9. Derrick Henry 3,496 posts
10. Bateman 3,461 posts
11. Happy Halloween 457K posts
12. Tulane 7,817 posts
13. #TNFonPrime 1,746 posts
14. Kyle Hamilton N/A
15. Georgetown 2,915 posts
16. #RHOC 1,658 posts
17. #PhinsUp 3,153 posts
18. UTSA 2,215 posts
19. #BALvsMIA N/A
20. Phillips 492K posts

Something went wrong.