I feel like my brain just isn't working correctly, but here is what I am trying to do.
I have 2 tables, I need to add a column to the first table, and then do a lookup for the "ITEM ID" from the second table and return the "VERIFY" number to the NEW column in the first table.
I am pretty sure this is a decently simple Index match formula, but for the life of me I am not getting it to work...
First Table: (1 Column)
<tbody>
</tbody>
<colgroup><col></colgroup><tbody>
</tbody>
<tbody>
</tbody>
Thanks for any help!
-Ben
I have 2 tables, I need to add a column to the first table, and then do a lookup for the "ITEM ID" from the second table and return the "VERIFY" number to the NEW column in the first table.
I am pretty sure this is a decently simple Index match formula, but for the life of me I am not getting it to work...
First Table: (1 Column)
Folder ID |
04.315.201 6/11/2019 PO 1 |
04.315.201 6/11/2019 PO 2 |
04.315.202 6/11/2019 PO 1 |
04.315.202 6/11/2019 PO 2 |
04.315.311 6/11/2019 PO 1 |
04.315.311 6/11/2019 PO 2 |
<tbody>
</tbody>
Second Table: (2 Columns) |
<colgroup><col></colgroup><tbody>
</tbody>
ITEM ID | VERIFY |
04.315.201 | 1 |
04.315.202 | 2 |
04.315.311 | 3 |
<tbody>
</tbody>
Thanks for any help!
-Ben