This is probably very easy but I have no idea how to do this and I don't know what to google to find the answer.
In the attached file I am trying to do the following.
1. Enter a quantity in cell F3. For example "3"
2. I want cell J3 to pull the number "3" from F3 > look at sheet 2 "Print Size & Quantity" > find the price for the 8x8 print QTY 3. In this example it is cell B5 and the value is $5.44.
3. I want cell J3 to display the value from sheet 2 cell B5 > "$5.44"
I know this is basic stuff. sorry.
Pricing.xlsx
Bookmarks