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 ...