Hello,
I'm using the following formula to index and match, but I need it to return a "text" instead of 0
=INDEX(All_Appended[#Data],MATCH($Q$3,All_Appended[client ID],0),MATCH(O11,All_Appended[#Headers],0))
what should I add to it to return "No Data Found" instead of the 0?
Thanks for helping.
Bookmarks