In effect, Excel is creating an AND logical sequence ... You can only look up one record at a time. Each lookup requires its own heading and criteria. Use XLOOKUP (or VLOOKUP if the return array ...
Some results have been hidden because they may be inaccessible to you