I want to do with the index found small and midsize cars can be well matched, but large car display value, not with errors, please help!
The first picture is charging standard table, the second chapter matching table is a function of my above, ask ace to see what's wrong
CodePudding user response:
Match () will be the third parameter to write full of 0 meaning exactly match, otherwise require array sorted,This, you don't need two function combination, direct vlookup () should be ok,