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
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),"")
=IFERROR(Staff_tbl[Staff Name (KEY)],Staff_tbl[Supervisor]=$H2),"")
Never mind. I left a bunch out of the formula. Lol!
- It worked just fine after all! I pretty much suck at this, but I'm getting better. Thanks to this forum. 🙂