I think Index Match is what I want but not getting results I want: (and
that's why I'm here asking, you all are the best :-)



Sheet 1 - table 1 - criteria E5:G176

Col E Col G
MWFS TSBGE
MWFS TSBGK
MWF PURNC
MF NPUOT
WS SMPHP
M SCCS
M WESTVS
W MUGMC
F STAHM


Sheet 2 - return results E5:E176

I need to match all cells that contain M(onday) in column E on sheet1
and return the customer code that is in column G sheet1

Sheet 3 will be for W(ednesday)
Sheet 4 will be for F(riday)
Sheet 5 will be for S(aturday)


Hope this clear and provides enough info.
Thank you!