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
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
<tbody>
</tbody>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
Column A | Column B |
<tbody>
</tbody>
Section: Ab |
<tbody>
</tbody>
Name: | ----ID: |
X | C |
Y | E |
<tbody>
</tbody>
Column C | Column D |
<tbody>
</tbody>
Section: Cd |
<tbody>
</tbody>
Name: | ----ID: |
G | J |
H | K |
<tbody>
</tbody>
Sheet 2
Column A |
<tbody>
</tbody>
Name |
=FORMULA ID: (J) |
=FORMULA ID: (C) |
<tbody>
</tbody>
Thanks for any help that is provided!