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
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
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.