Please convert my XLOOKUP to an INDEX and MATCH

[Ioweyouone]

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))

 

[mamady]

Hi Dear,

Ideally, it is better to arrange the data set into a tabular form.

Nonetheless, please try the following formula
=IFERROR(INDEX(nov_qty,MATCH(E8,nov,0)),0)+IFERROR(INDEX(dec_qty,MATCH(E8,dec,0)),0)+IFERROR(INDEX(jan_qty,MATCH(E8,jan,0)),0)+IFERROR(INDEX(feb_qty,MATCH(E8,feb,0)),0)

Best Regards

 

[Ioweyouone]

Works perfect.
Bless your heart mamady! I'm grateful to people like you that are willing to help.

 

[mamady]

Works perfect.
Bless your heart mamady! I'm grateful to people like you that are willing to help.

my pleasure