Return 3rd value if 1st and 2nd value are both in list (Updated Information Post)
Apologies for the 2nd post. Some of the information I was given wasn't correct. I've now been filled in properly so can explain clearer.
I have a workbook with 2 sheets. Both have identical layouts, but not all of the same data. For ease of understanding, Sheet A is Current, Sheet B is Previous. On both, column I is "PO Number", Column N is "Description", and Column AI is "Closed?". There may be instances where a row in Current doesn't appear in Previous (and vice-versa), and should just display "No data". There is also gaps in the data, and sorting both sheets doesn't work due to some rows not appearing.
On the Current sheet, I am trying to get column AI to print what column AI says on the Previous sheet in the instance that Current PO Number and Current Description on that row both match the Previous PO Number and Description.
I have attached an example workbook here, for ease of understanding, too.
[link] [comments]
Want to read more?
Check out the full article on the original site