Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
60
Views
Topic starter
My Vlookup formula works perfectly. I have a value that states "No Purchase Order" which I would prefer to not show up in the results. I think I need an IF statement, but can't get it to work properly. Here is the formula I have tried that does not work:
= IF(VLOOKUP($A7,$A$1:$B$4,2,0)="No Purchase Order","-")
How can I get "No Purchase Order" to return a value of "-" or " " ?
Thank you!
Posted : 28/08/2017 12:02 am
Hi Helene,
Apart from that you will get a #N/A result when the condition is false, as you have not completed the IF formula to handle such scenario, you should not have any problems.
Please share a sample if you still have issues.
Br,
Anders
Posted : 28/08/2017 8:47 am
