LinkBack URL
About LinkBacks
Hi,
I have used the below syntax but its not pulling data.
What's wrong in this syntax
Please Login or Register to view this content.
Hi,
I have used the below syntax but its not pulling data.
What's wrong in this syntaxPlease Login or Register to view this content.
Last edited by paradise2sr; 09-02-2022 at 02:42 AM. Reason: it was reference for Private workbook
You ought to know by now what you need to do to get help ... Workbook, please!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Pls find sample file.
Try this:
=FILTER(AC!A5:B9,ISNUMBER(SEARCH(C1,AC!C5:C9)*(C1<>"")),"No results")
Last edited by AliGW; 09-02-2022 at 03:07 AM. Reason: Added example workbook.
Thankx for the prompt reply.
Would like to add a condition further, that if C1 is blank then it should not show the result, as currently it is shown wrong result when C1 is blank.
Maybe this:
=IF(C1="","",FILTER(AC!A5:B9,ISNUMBER(SEARCH(C1,AC!C5:C9)*(C1<>"")),"No results"))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Please try =FILTER(AC!A5:B9,(C1<>"")*ISNUMBER(SEARCH(C1,AC!C5:C9)),"No results").
The test on C1 must be placed outside of ISNUMBER, otherwise you will get ISNUMBER(0) = TRUE
Thanx all of u.My issue gets solved.
You're welcome, thx for the rep. I also learned from answering your question.
Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks