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.
Summary tab
Offer 1 tab
I cant find examples that are set up the same way I have mine, and unable to set up the formula correctly.
Thanks for any assistance.
I’ve tried the below formula, but returning a reference error
=VLOOKUP($A3, INDIRECT(“‘”&B$1 &”‘!”&”B1:D1”), 3, 0)
My expected return is value ‘5’ as that is the Qty Ordered value on tab 1, cell D1
Katie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
4