Combined use of ISBLANK, VLOOKUP, IFERROR

PRADEEPSWALSE

New Member
Joined
Nov 27, 2018
Messages
20
Office Version
  1. 2013
Platform
  1. 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’?

Book2.xlsx
B
3weweh
Sheet1
Cell Formulas
RangeFormula
B3B3=IFERROR(VLOOKUP(A3,F3:G5,2,FALSE),"")


Regards,
Pradeep
 

Attachments

  • ISBLANK.JPG
    ISBLANK.JPG
    31.8 KB · Views: 6

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,134
Office Version
  1. 365
Platform
  1. Windows
Glad we could help & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,719
Messages
5,524,459
Members
409,581
Latest member
khin

This Week's Hot Topics

Top