I went back to the original formula and referenced the work order numbers and it worked.
=INDEX($B$2:$B$999,MATCH(1,(J11=$H$2:$H$999)*(N11=$F$2:$F$999),0))
Thanks again
I went back to the original formula and referenced the work order numbers and it worked.
=INDEX($B$2:$B$999,MATCH(1,(J11=$H$2:$H$999)*(N11=$F$2:$F$999),0))
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks