Hi
I have a Query (attached) that calls a table (t_Names) from the workbook.
If the table does exist then I want the Query to perform a series of steps otherwise I want it to perform an alternative series of steps.
How does one structure this in a Query?
Kind Regards
Allister
G12 =IFERROR(IF(MATCH($F12,$F$4:$F$8,0)>0,"OK","Error"),"Error") and drag down.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thanks but I was wanting Power Query solutionOriginally Posted by oeldere
The PQ solution could be as short as:
See attached.
Please Login or Register to view this content.
After removal of t_Names from Sheet named Table2 you have to refresh the query to see the message changes to ERRORs
Last edited by Kaper; 07-26-2022 at 02:23 AM. Reason: removed = true in (try Excel.CurrentWorkbook(){[Name="t_Names"]}[Content])[HasError] = true
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks