Removing "FALSE" from an IF statement with a VLOOKUP
Solved/Closed
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!
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:
- Remove false from if statement
- How to remove false'' from if statement excel - Best answers
- How to remove false from excel - Best answers
- Fenix internet on bank statement - Guide
- How to remove story from close friends - Instagram Forum
- Removing " false" value in "IF" ✓ - Office Software Forum
- How to remove call barring in keypad mobile - Word Forum
- How to remove tiktok shop from my profile ✓ - TikTok Forum
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 24, 2016 at 09:23 AM
Mar 24, 2016 at 09:23 AM
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
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