Hi,
I'm trying to do something but I'm not sure that it is possible. I have tasked myself with wanting to return a data type from validation that is not the same as inputted.
I have a table which can be updated which I would like to use as a basis for validation. I also use this table as a data source in order to construct a Data Type using Power Query. This data type uses the name of the search as its own name.
What I would like to do is have a search entry that when I start typing in the name of the lookup, it will return the new fancy data type. Although I'm not sure that this is an option.
I have attached an excel example to this post which demonstrates what I want to achieve.
I'm using Office 365 and am hoping to use Excel for Online to publish, so ideally avoiding VBA, although that is not a hard rule.
Thank you
Bookmarks