This will find a match regardless of the sort order. Since we are looking for an exact match and we don't know if the array is sorted, we want to make sure that the match_type parameter in the MATCH function is set to 0. I was hoping for an easier formula than this: =IF(OR(B94=Overview!D$54,B94=Overview!D55,B94=Overview!D56, ),'FS','Bulk')Īnswer: When you are using the MATCH function, you need to be aware of a few things.įirst, you need to consider whether your array is sorted in a particular order (ie: ascending order, descending order, or no order). Question: In Microsoft Excel, I tried this MATCH formula but it did not work: =IF(MATCH(B94,Overview!D$54:D$96),'FS','Bulk')
