PRADEEPSWALSE
New Member
- Joined
- Nov 27, 2018
- Messages
- 28
- Office Version
- 2013
- Platform
- Windows
Hi,
I want to use multiple cases in single cell.
Case 1 : In ‘B3’ cell value are appearing by using VLOOKUP from cell ‘A3’
Case 2 : Want to use IFERROR to avoid #N/A in cell ‘B3’
Case 3: If cell ‘C3’ is empty then cell ‘B3’ should return to empty.
I am able to combine case 1 and case 2. Now I want to combine all three cases.
Which formula I should use in cell ‘B3’?
Regards,
Pradeep
I want to use multiple cases in single cell.
Case 1 : In ‘B3’ cell value are appearing by using VLOOKUP from cell ‘A3’
Case 2 : Want to use IFERROR to avoid #N/A in cell ‘B3’
Case 3: If cell ‘C3’ is empty then cell ‘B3’ should return to empty.
I am able to combine case 1 and case 2. Now I want to combine all three cases.
Which formula I should use in cell ‘B3’?
Book2.xlsx | |||
---|---|---|---|
B | |||
3 | weweh | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B3 | B3 | =IFERROR(VLOOKUP(A3,F3:G5,2,FALSE),"") |
Regards,
Pradeep