I'm using an xlookup to reference some data and the formula looks like this : =XLOOKUP($F7,QB_Details!$DI$2:$DI$79,QB_Details!$D$2:$D$79,"No Record",0)
This works fine but I was curious if there is a way to make it more dynamic so these parts: =XLOOKUP($F7,QB_Details!$DI$2:$DI$79,QB_Details!$D$2:$D$79,"No Record",0)
could be altered to account for many different lookup tables, instead of QB it could be 20 other designations that come before "_Details". The dimensions of all the arrays are identical so no need to alter that part of the lookup.
I wanted to have it where a user can select that first part that says QB with one of 20 different choices and then have it point to the proper worksheet. Sorry I don't know if I'm being very clear but let's say they select XY from the dropdown, then the lookup would be =XLOOKUP($F7,XY_Details!$DI$2:$DI$79,XY_Details!$D$2:$D$79,"No Record",0) instead.
I've been looking around for this and haven't seen something that works so far.
Thanks in advance if anyone knows the answer.
Rayburn
Bookmarks