Try it like this:
=IF(AND(ISNUMBER(MATCH('WO Operations'!A5,Schedules!$A$1:$A$4000,0)),ISNUMBER(MATCH('WO Operations'!B5,Schedules!B5))),"",'WO Operations'!A5)
Hope this helps.
Pete
Try it like this:
=IF(AND(ISNUMBER(MATCH('WO Operations'!A5,Schedules!$A$1:$A$4000,0)),ISNUMBER(MATCH('WO Operations'!B5,Schedules!B5))),"",'WO Operations'!A5)
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks