Vlookup returning false as value

I am trying in include an IF statement to say that if the cell says "PAINT" do one thing and if it says anything else, do another (VLOOKUP) If The cell says PAINT then it works as it should. However, if the cell says anything else then I get a value of "FALSE". I am new to VLOOKUP so I suspect that could very well be the problem.

Thank you

=IF(N20="Paint",P20-(VLOOKUP(B20,CODES!$F$2:$G$22,P20-(VLOOKUP(B20,CODES!$J$2:$K$22,2)))))

Answers


You will need to do something like

 =IF(N20="paint",VLOOKUP(B20,CODES!$F$2:$G$22,2,0),VLOOKUP(B20,CODES!$J$2:$K$22,2,0))

At the end of your first VLOOKUP you need to specify which column to return the value from on your 'CODES' sheet, I've pointed to Col G by using '2' and '0' returns an exact match. Then close the 'True' VLOOKUP and start your False VLOOKUP


Need Your Help

Is it possible to register software as a game controller device?

.net c windows driver

I've seen questions like this stackoverflow question. However, in this and many other discussion like it the end result tends to be spamming keyboard events instead of operating, and being recogni...

How to use javascript history API

jquery ajax html5 history pushstate

In github's blog post about how they created the new tree slider, they give this as the code used:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.