Hello I have the attached spreadsheet that kind of works, It returns the correct value when it exist but it doesn't when the value doesn't... could you please look at my formula and let me know where I was wrong.
Thanks!!
Hello I have the attached spreadsheet that kind of works, It returns the correct value when it exist but it doesn't when the value doesn't... could you please look at my formula and let me know where I was wrong.
Thanks!!
You could use:
Formula:Please Login or Register to view this content.
But I think what you were shooting for was:
Formula:Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Please Login or Register to view this content.
Ben Van Johnson
Another way
=IF(IFERROR(MATCH(F1,A:A,0),0),"","NOT CIB ")&"Approved"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks