VLOOKUP, ARRAY, ROW, COLUMN please help!!!

I need a formula that will search the item # from table 1 in table 2 and display the number for each individual category ("inca", "ineb", etc.) The lines that do not have sales I want it to display a...