Need Vlookup and Indirect Formula
I’ve never used the Indirect formula so looking for some help.
I want to reference the Offer # on the ‘Summary’ tab to look up the Total Qty Ordered value on the tab titled #1.
So, for Offer #1 (cell A3) on the Summary tab, look up on the tab titled “1”, vlookup the offer # (cell b1) and return the Qty Ordered value (cell D1) into cell H3 on the Summary tab.