Intersection Formula

[jjm3066]

I have a grid with SKUs running in Column 1 from rows 1:20. In Row 1, I have Store numbers running from B:FQ. In the grid, it lists how many of those SKUs sold for each SKU number.

I want to be able to place those sales numbers in abnother workbook. In the workbook, Column A is a concantenate of the SKU plus store number. How do I easily lookup the Column and Row in the first workbook-- find the intersection (sales number), to match the concantenate in Column A of the second workbook and place in Column B.

I dont know how to write code, so be gentle on me.

Thanks!

 

[Gerald Higgins]

Are you easily able to break up the concatenated SKU and store number into the two separate components ?