Report

Removing "FALSE" from an IF statement with a VLOOKUP [Solved]

Ask a question RayRay - Latest answer on Mar 29, 2016 09:05AM
Hello,
I would like to remove the "FALSE" result I get when using my IF formula.
The formula is a VLOOKUP that is looking at 2 different cells.
=IF(B1>0,VLOOKUP(B1,'Customer Number'!A2:C415,3,FALSE),IF(B2>0,VLOOKUP(B2,'Partner Number'!A2:B25050,2,FALSE)))
Any help would be great!
See more 
Helpful
+0
moins plus
RayRay, good morning.

The problem is missing the action about 2nd IF

See it below:

=IF( B1>0,
.............VLOOKUP(B1,'Customer Number'!A2:C415,3,FALSE),
.............IF( B2>0,
.........................VLOOKUP(B2,'Partner Number'!A2:B25050,2,FALSE),
.........................??? (What to do?)
................)
......)

Fill any action to this 2nd part of IF and it´s OK.
Please, tell us if it worked for you.

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Add comment
Helpful
+0
moins plus
This worked, Thank you.
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!