Hello all,
I am using Excel 2010. Looking for some help with a template i am creating for work to find duplicates that match both the column A and B values exactly in another sheet. I work with purchase orders and when a we are trying to track what purchase order AND line items vendors are sending pricing back for. A PO May have multiple line items that each need their own price confirmed.Its setup like this
<tbody>
</tbody>
A list of outstanding PO's that have not been priced is on Sheet1 Starting in cell A14, and the PO's they have sent back are on Sheet2 in the same format (Col A,B). The formula i am using currently works, but only references the PO Number column, and not the corresponding line item in Column B as well. I want the text "Updated" in column C just as it is doing now but only when the PO and Line item match exactly. My current formula is below. Can this be done without using a specific VBA Script for each individual vendor using a formula?![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I am using Excel 2010. Looking for some help with a template i am creating for work to find duplicates that match both the column A and B values exactly in another sheet. I work with purchase orders and when a we are trying to track what purchase order AND line items vendors are sending pricing back for. A PO May have multiple line items that each need their own price confirmed.Its setup like this
Column A (PO Number) | Column B (Line item) |
123456789 | 1 |
123456789 | 2 |
<tbody>
</tbody>
A list of outstanding PO's that have not been priced is on Sheet1 Starting in cell A14, and the PO's they have sent back are on Sheet2 in the same format (Col A,B). The formula i am using currently works, but only references the PO Number column, and not the corresponding line item in Column B as well. I want the text "Updated" in column C just as it is doing now but only when the PO and Line item match exactly. My current formula is below. Can this be done without using a specific VBA Script for each individual vendor using a formula?
Code:
=IF(ISERROR(MATCH(A14,'Sheet2'!A:A,0)),"","Updated")
Last edited: