raymondboze
New Member
- Joined
- Jan 27, 2018
- Messages
- 1
Trying to do an Index and Match looking for one particular criteria in multiple ranges of cells and display the value of the matched cell elsewhere in a workbook. For example: I want the value in the second column where it is matched to the value of the cell in the third column to display on a second worksheet.
<tbody>
</tbody>I have figured out that part but what I can't figure out is how to get it to do the same thing if say for example the "A31" in the third column was where the "A41" is in the sixth column. Basically I need it to do this for a total of 9 columns and wherever it finds "A31" at i need the value in the cell to the left of it to display elsewhere. Can anyone help me with this?
T456 | 6 | A31 | T485 | 4 | A11 |
T456 | 4 | A21 | T485 | 3 | A41 |
T456 | 6 | T485 | 6 |
<tbody>
</tbody>