Multiple IF statements in a VLOOKUP.

[gbenson]

I am sure this will be very easy, but I am screwing something up in my text. I have this, which works, but I need to add an additional IF statement for <=0. I know this is probably very simple, so any help is appreciated.

=IF(VLOOKUP(F1:F30, [Book2]Sheet1!$A$1:$H$2630,8,0)>=0, "YES", "NO")

 

[Joe4]

Welcome to the Board!

Firstly, the first argument in the VLOOKUP function should be a single cell, not a whole range. If you want to do it for all of F1:F30, you would copy the formula down 30 times.

To do what you want, you need a nested IF statement, i.e.

[COLOR=#333333]=IF(VLOOKUP(F1, [Book2]Sheet1!$A$1:$H$2630,8,0)>=0, "YES", [/COLOR][COLOR=#333333]IF(VLOOKUP(F1, [Book2]Sheet1!$A$1:$H$2630,8,0) < 0,""[/COLOR][COLOR=#333333]))[/COLOR]

A few things to note:
1. You are already checking >=0. Can it return anything other than a number? If not, then you don't need to check for less than zero, as number can only be one of the two options, there is no other.
If the concern is it could return an error, you can use the IFERROR statement instead of a nested IF statement.
2. Your original formula says >=0. And then you are asking about <=0. That is overlapping. What do you want to happen if it equals 0 (0 satisifies BOTH those conditions). The equal sign should only appear in one of those options, not both.

 

[gbenson]

Hi Joe, thanks for the help. Yes, I will clean up the formula next time. Removing the 2nd '=' did it.