Need help translating a formula in a cell

[newguyhere]

Hello Excel Experts!!!!

I'm trying to figure out where values in an excel worksheet came from however am limited by my knowledge of Excel. I'm hoping someone here can break down this formula for me as my own research has left me more confused. To make a long story short:

Sheet 1 has summary tables of the data that is on sheet 2. Kind of like a dashboard. Sheet 2 has the data. In trying to figure out where the table values in SHeet1 it has this formula for each cell with maybe 1 value changed for each cell. The formula is as follows. Can someone please explain how to interpret this so I can go to sheet2 and see where it is getting the data from.

[FONT=wf_segoe-ui_normal]<style type="text/css"><!-- .rps_bc06 p.x_MsoNormal, .rps_bc06 li.x_MsoNormal, .rps_bc06 div.x_MsoNormal{ margin: 0in; margin-bottom: .0001pt; font-size: 11.0pt; font-family: "Calibri",sans-serif; }.rps_bc06 span.x_MsoHyperlink{ color: #0563C1 ; text-decoration: underline; }.rps_bc06 span.x_MsoHyperlinkFollowed{ color: #954F72 ; text-decoration: underline; }.rps_bc06 span.x_EmailStyle17{ font-family: "Calibri",sans-serif; color: windowtext; }.rps_bc06 .x_MsoChpDefault{ font-family: "Calibri",sans-serif; </style>=IFERROR(INDEX(Sheet2!$F:$F,MATCH(E$5&$C11&$D$5,Sheet2!$E:$E,0),1),0
[/FONT]
Thanks in Advance

 

[yky]

[FONT=wf_segoe-ui_normal]=IFERROR(INDEX(Sheet2!$F:$F,MATCH(E$5&$C11&$D$5,Sheet2!$E:$E,0),1),0[/FONT]

The formula is incomplete. Is it missing only a parenthesis or maybe some other things are missing also?

 

[newguyhere]

Your right, it’s missing the closing ).

 

[yky]

[FONT=wf_segoe-ui_normal][FONT=wf_segoe-ui_normal]https://www.techonthenet.com/excel/formulas/index.php [/FONT]is a good site to look up the usage of Excel functions.

MATCH(E$5&$C11&$D$5,Sheet2!$E:$E,0) looks for the string E$5&$C11&D$5, which is the concatenated string of the strings in E$5, $C11, and D$5, in the column E in sheet2. 0 tells MATCH to find exact match. MATCH, in this case, returns the row number of the matched cell, i.e. if a match is found. Otherwise, it returns an error.

[FONT=wf_segoe-ui_normal]INDEX(Sheet2!$F:$F,MATCH(E$5&$C11&$D$5,Sheet2!$E:$E,0),1) returns the value in cell FN, where N is the number returned by MATCH. If MATCH returns 11, then the cell value in F11 is returned.

[/FONT][FONT=wf_segoe-ui_normal]IFERROR(INDEX(Sheet2!$F:$F,MATCH(E$5&$C11&$D$5,Sheet2!$E:$E,0),1),0) returns 0 if MATCH or INDEX returns an error. Otherwise, it returns what INDEX returns.[/FONT]
[/FONT]