Forum Discussion
Solved
Help Needed: Nest XMATCH in h-linked drop-down to land on first blank record in the destination Tab
I'm sorry to post again. My last post was not clear enough. Lots of views, but no answers. I'm not very practiced at asking questions in the forum. Please bear with me and don't hesitate to offer pos...
Please stay on the cell with drop-down list, when on ribbon Data->Data validation. It looks like
In Source it could be text as here, or usually reference on the range within workbook. Expand reference with names of new tabs and correct the Source above. It will be like
If drop-down is in cell B2 and we speak about first column in another sheet, that could be
=HYPERLINK("#" & ADDRESS(XMATCH(,INDIRECT("'" & B2 & "'!A:A") ),1,,,INDIRECT("B2") ), "mycell" )
- Thank you very much for your response! I'm not sure if this is to be nested in my original formula or is this a replacement for the way I'm approaching it. One thing I just noticed is that I'm not able to add to my list of 'office tabs' and have it expand accordingly in my drop-down. Somehow, I need to use a named list that automatically expands. I will be adding many offices (new office tabs) down the road. I'm not very good at this stuff with my limited understanding of the functions and their syntax.
Please stay on the cell with drop-down list, when on ribbon Data->Data validation. It looks like
In Source it could be text as here, or usually reference on the range within workbook. Expand reference with names of new tabs and correct the Source above. It will be like
- LOL! I just figured out that I could download the attached file and open it in Excel. Duh!! Thank you so much. I was trying to make this much more complicated than it needed to be. Excellent and simple solution! Thanks again!!
