Hello everyone, i'm having a problem trying do muplitple lookups, i will add a spread sheet to see what im having the issue with. I want when i select my color drop down menu it would show my quantity just as when i select my size drop down menu it show me the quantity in the same cell.
=VLOOKUP(A7,DATA!F13:K15,HLOOKUP(INVENTORY!E7,DATA!F11:K12,2,0),0)