Removing "FALSE" from an IF statement with a VLOOKUP [Solved/Closed]
RayRay -
Mar 23, 2016 at 03:16 PM - Latest reply: RayRay
- Mar 29, 2016 at 09:05 AM
- Removing "FALSE" from an IF statement with a VLOOKUP
- Removing false statement » Forum - Excel
- Removing " false" value in "IF&quo [Solved] (Solved) » Forum - Office software
- Remove False from cell (Solved) » Forum - Office software
- Need help to remove FALSE from cell (Solved) » Forum - Office software
- Removing false in excel (Solved) » Forum - Excel
2 replies
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