I am trying to match based on criteria in 3 columns. I have been using
the CONCATENATE to match in multiple columns.

Dept Type Category Qty
Lighting Floor Lamp Standard 10
Lighting Desk Lamp LED 12
Electrical Electrical Plugs Contractor 15
Electrical Power Strips 6 pin 20
Power Tools Drill 18v 5

If I wanted to find the qty for LED Desk Lamp I would
index(d2:d6,match("lighting"&"Desk
Lamp"&"LED",CONCATENATE(A2:A6,B2:b6,C2:c6),0),4))

Is there another way besides the CONCATENATE funtion to achieve the
same result like if statements? I do not want to use the indirect or
offset function in the formula.

Seán