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
On desktop we may use CELL("filename") and extract sheet name with formula from it. On web that function doesn't work. There is workaround with set of formulae but, from my point of view, not reliable. If you don't rename sheets often, much easier to duplicate sheet name in one of the cells.
Ok. Thanks for the information. I will do it the safe way. I'll be sure to let you know how it goes. Thank you again for all your help!
- It worked just fine after all! I pretty much suck at this, but I'm getting better. Thanks to this forum. 🙂
- Never mind. I left a bunch out of the formula. Lol!
- When I try to enter the formula for IFERROR, it forces the table and column name instead of letting me use the range. Then it returns an error that doesn't offer any suggestions. Here is what it looks like...
=IFERROR(Staff_tbl[Staff Name (KEY)],Staff_tbl[Supervisor]=$H2),"")