Ioweyouone
New Member
- Joined
- Aug 14, 2009
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
The XLOOKUP formula below works fine but my co-workers cannot use XLOOKUP. Can someone help me convert this to an INDEX and MATCH? My INDEX & MATCH thought process below does not work. Thanks
XLOOKUP(E8,nov,nov_qty,XLOOKUP(E8,dec,dec_qty,XLOOKUP(E8,jan,jan_qty,XLOOKUP(E8,feb,feb_qty)))) |
INDEX(nov_qty,MATCH(E8,nov,0)),INDEX(dec_qty,MATCH(E8,dec,0)),INDEX(jan_qty,MATCH(E8,jan,0)),INDEX(feb_qty,MATCH(E8,feb,0)) |