Hello All,
I am trying to use a Vlookup that when I change an option from the dropdown menu the table changes the range ( A1:A15 to A17:A24) in the source file for the tab and base file name are the same but February will change to March, then April.
I am trying to use this formula pieced together from reading forums but still having no luck. The Concantenate formula returns the right words to find the file and tab but I cannot get it to work inside the Vlookup.
=CONCATENATE("'[February 2018 Raw Data File.xls]",T48,Q48), T48 is tab name (By Division and Budget Category) and Q48 is the range (A1:A15)
=VLOOKUP(J21,T52,2,False) This is my Vlookup where T52 is the concatenate formula in cell T52.
Still working on getting the February to change March and such.
I get an error: #REF
Any help you guys can give would be great. Also read it might need to be done in VBA.
I am trying to use a Vlookup that when I change an option from the dropdown menu the table changes the range ( A1:A15 to A17:A24) in the source file for the tab and base file name are the same but February will change to March, then April.
I am trying to use this formula pieced together from reading forums but still having no luck. The Concantenate formula returns the right words to find the file and tab but I cannot get it to work inside the Vlookup.
=CONCATENATE("'[February 2018 Raw Data File.xls]",T48,Q48), T48 is tab name (By Division and Budget Category) and Q48 is the range (A1:A15)
=VLOOKUP(J21,T52,2,False) This is my Vlookup where T52 is the concatenate formula in cell T52.
Still working on getting the February to change March and such.
I get an error: #REF
Any help you guys can give would be great. Also read it might need to be done in VBA.