Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

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

Answer 1 / 2
Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
 144
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
Answer 2 / 2

This worked, Thank you.
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!