'Xlookup' auto-update by Offset rule

[shahinsyr]

Hi everyone,
I am struggling modify my 'Xlookup' function getting updated automatically using an Offset rule.

Here is what I'm trying to do:

As you see in the below picture, on the right side, I have a drop down menu and when I choose a product from the drop down menu the specification changes for that product based on the sources on the right side. This is the formula for this :

=XLOOKUP(G2,A2:A4,B2:D4)

now what I want to do is that later Im gonna add more values on the right side, including more products and their specifications, and I want what I have made on the right side updates according to that. So I need to:

1- make a function to update my drop down menu automatically, which I already did with putting and Offset formula in the Data Validation section source.

2- make a function for my Xlookup formula to be updated automatically, which means when I add more products with their specs on the left side, I wouldn't need to update my Xlookup manually. I would like to do this with an Offset function rather than making tables.

I appreciate if you tell me how to do the second point.

 

[Peter_SSs]

Welcome to the MrExcel board!

Perhaps i am not understanding, but why not just make your XLOOKUP ranges big enough to cover any amount of additions you are likely to make. For example

=XLOOKUP(G2,A2:A1000,B2:D1000)

 

[shahinsyr]

Oh my goodness!

Many thanks Peter, how stupid of me that it didnt come to my mind to do this. Thanks a lot

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.
Yes, sometimes the simple solutions just don't come to mind.