IF Formula Shown FALSE Results
Hello.
So i'm a noob in Excel. I'm trying to get a logic that is
"If column T is filled, it's already assessed. But if column T is empty, is either "Perform" or "Not Perform" based on the LOOKUP formula that i've inserted"
My formula is
=IF(T7<>"","Sudah Ases",IFERROR(VLOOKUP(D7,'Transit '!$Q$818:$Q$823,1,0),"Belum") = "Perform")
Screenshot (1).png
Please help me with my work. Thank you.
Last edited by AliGW; 02-07-2022 at 06:39 AM. Reason: Tagged as solved - no need to edit the thread title!
Welcome to the forum.
Maybe this???
=IF(T7="",IF(VLOOKUP(D7,'Transit '!$Q$818:$Q$823,1,0)="Belum","Perform","Not Perform"),"Sudah Ases")
If not, there are instructions at the top of the page explaining how to attach your sample workbook.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi there.
A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.
Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected 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
Your outcome is based on whether the value in D7 is found in Q818:Q823 on the Transit sheet? How about?
Also check the name of the "Transit " sheet really does have a space and make sure the "Perform" and "Not Perform" are the right way round - just swap them if not.
Please Login or Register to view this content.
WBD
Office 365 on Windows 11, looking for ✶ rep!
Thanks for your help but eventually the formula is not workingWelcome to the forum.
Maybe this???
=IF(T7="",IF(VLOOKUP(D7,'Transit '!$Q$818:$Q$823,1,0)="Belum","Perform","Not Perform"),"Sudah Ases")
If not, there are instructions at the top of the page explaining how to attach your sample workbook.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.But i'm really glad there's someone willingly help my work.
I'm sorry sir i'm not reading the yellow banner top. I will make sure i'm post the example sheets next time.Hi there.
A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.
Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
Thanks for replying and i'm looking forward to get help from you
IT'S WORKING. Thank you so much for your help, i think i never use the ISNUMBER and MATCH formula before. I'll note this information for my next project.Your outcome is based on whether the value in D7 is found in Q818:Q823 on the Transit sheet? How about?
Copy to clipboard
=IF(T7<>"","Sudah Ases",IF(ISNUMBER(MATCH(D7,'Transit '!$Q$818:$Q$823,0)),"Perform","Not Perform"))
Also check the name of the "Transit " sheet really does have a space and make sure the "Perform" and "Not Perform" are the right way round - just swap them if not.
WBD
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
In future, please don't quote whole ppsts - it's just clutter!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks