Hey guys, I need a formula that will find a value based on a columns criteria. EX: I am trying to find the opposite of INDEX(x,MATCH(, as it is used for finding values based on a rows criteria.
Sheet 1
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Section: Ab[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name:[/TD]
[TD]----ID:[/TD]
[/TR]
[TR]
[TD]X[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Y[/TD]
[TD]E[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Column C[/TD]
[TD]Column D[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Section: Cd[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name:[/TD]
[TD]----ID:[/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]K[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Column A[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Name[/TD]
[/TR]
[TR]
[TD="align: center"]=FORMULA ID: (J)[/TD]
[/TR]
[TR]
[TD="align: center"]=FORMULA ID: (C)[/TD]
[/TR]
</tbody>[/TABLE]
I am using an Index MATCH formula to get the name in the "=FORMULA" cells, what i require is an extension to this formula that will also write what section the ID came from EX: INDEX(MATCH())&"INSERT FORMULA HERE". So what it should say in Row 3 of sheet 2 is: "G, From Section Cd". While in row 4 it should say: "C, From Section Ab.".
Thanks for any help that is provided!
Sheet 1
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Section: Ab[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name:[/TD]
[TD]----ID:[/TD]
[/TR]
[TR]
[TD]X[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Y[/TD]
[TD]E[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Column C[/TD]
[TD]Column D[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Section: Cd[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name:[/TD]
[TD]----ID:[/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]K[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Column A[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Name[/TD]
[/TR]
[TR]
[TD="align: center"]=FORMULA ID: (J)[/TD]
[/TR]
[TR]
[TD="align: center"]=FORMULA ID: (C)[/TD]
[/TR]
</tbody>[/TABLE]
I am using an Index MATCH formula to get the name in the "=FORMULA" cells, what i require is an extension to this formula that will also write what section the ID came from EX: INDEX(MATCH())&"INSERT FORMULA HERE". So what it should say in Row 3 of sheet 2 is: "G, From Section Cd". While in row 4 it should say: "C, From Section Ab.".
Thanks for any help that is provided!