Need help I have four sheet and one master list im trying to figure out how can i combined this formula:
=IFERROR(INDEX(CV[Column12],MATCH(D17,CV[Column5],0)),""),IFERROR(INDEX(AR[Column12],MATCH(D17,AR[Column5],0)),""),IFERROR(INDEX(EL[Column12],MATCH(D17,EL[Column5],0)),""),IFERROR(INDEX(ME[Column12],MATCH(D17,ME[Column5],0)),""))
CV - Sheet 1
AR - Sheet 2
EL - Sheet 3
ME - Sheet 4
D17 is from Master List Sheet and I have table in every sheet.
Thanks in advance!
Bookmarks