View Single Post
 
Old 03-29-2024, 11:00 AM
TessaMurillo TessaMurillo is offline Windows Vista Office 2010
Advanced Beginner
 
Join Date: Mar 2024
Posts: 33
TessaMurillo has a little shameless behaviour in the past
Default

You can use the INDIRECT function to change the reference to a dynamic named range in a formula in cell G. Simply enter the name of the named range you want in cell $K$2 (for example, Kin2_), then change the formula as follows:
:=INDEX(INDIRECT($K$2 & "_"), MATCH($D6, Item, 0))
The formula will now automatically use the named range specified in cell $K$2.
Reply With Quote