Multi-column Indexing [SOLVED]

TrackerTest01.xlsx

After doing some searching on this form I was unable to find an answer that would help.

For my first post I would ask for some help. I have been asked to provide my company with a work book that tracks the inventory in several of our focus stores. Attached is a small workbook identifying what I am trying to do.

I am trying to match 3 or 4 columns and then provide me with an indexed result.

for example I am trying to retrieve an indexed number for Cell B5. I need it to correlate with cells B4,A5, and B2. If I could get some help I would greatly appreciate it.

I read somewhere that by combining the 3 columns and creating a specific number somehow and then indexing that; that might work.

Again thank you in advanced I look forward to spending some time here.