I suspect it might be better to do a Filter in your 'Trenton Qtys' view to select only the rows associated with the 'WA' location, rather than a Calculated Column that outputs the quantity if the row represents the 'WA' location. That way, there is only one row per item number in the lookup view, and the 'Items to order' view only has one record per item to read to get the appropriate quantity.