Forum Discussion
Index and Match with Max Function
Hello, I have a question in regards to index and match. So I'm referencing information from another spreadsheet which is my company's receiving log using the index and match function. The issue I...
Hey Robert,
Sorry I have an additional question for the problem involving finding the latest date from the receiving log. So here is the formula used currently:
=IFNA(LOOKUP(2,1/("Here"'Daily Receiving Log .xlsx'!Daily_Receiving_Log[P.O. No.]=[@1st]),'Daily Receiving Log .xlsx'!Daily_Receiving_Log[Date]),"")
So I'm matching only the PO number, but I will also need to match the part number.
My question is, for this formula I tried adding an add (where I have in bold "here") constraint right after the look up function, matching the function match the PO and the part number, but it didn't not work. Is there another way to create two constraints for this formula so I'm not getting incorrect date information?
Thanks.
