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

Report
-
 RayRay -
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!
Related:

2 replies

Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
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
This worked, Thank you.