我谷歌而已。不会别问我。
Excel VLOOKUP For Multiple Results
The best way to lookup all the matches is the FILTER function, which is available for Excel Online and Excel for Microsoft 365.
Other Excel users will have to use a workaround to return all the matches, but it is still possible.
=FILTER(array,include,[if_empty])