Formatting Issues with Inventory Spreadsheet

Good Morning my friends. NBVC if you happen to be reading this, I hope this is not breaking a rule by wanting a certain moderator for help. I am so confused and the last time you helped me, my human errors were solved and the best part is I understood. However, I am needing a little more assistance. What I need for this spreadsheet to work efficiently is to have just Item Number and Color Code typed in and the UPC, Item Description, and Price Per Unit to automatically display.

IF($D23="","",INDEX(Price!B:B,MATCH($D23,Price!$H:$H,0)))

The formula above you helped me with allows for me to use only one reference (i.e. UPC number) to fill in the other cells. I am needing (I suppose) a dual reference type of formula. I don't really know all the names of formulas other than writing out a word problem and then matching a formula. lol. I have so many reference books in front of me and all of them are a hot second away from being tossed into a barrel and set on fire. And First on the List is Microsoft's Office 2003 Advanced Specialist Approved.
Best regards

IsleTurbo

So assuming you are entering values in B23 and D23, try in E23:

=IF(OR(B23="",C23=""),"",INDEX(Price!$H$10:$H$1185,MATCH(1,INDEX((Price!$B$10:$B$1185=$B23)*(Price!$C$10:$C$1185=$C23),0),0)))

copied down.

Same formula in other columns, just adjust the INDEX range.

Note: You can't use whole column references with this formula, however...

That is okay, if the UPC code is unique in the Price tab. And if that is the case, you can also simplify the description code similarly.