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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Fluff

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

Watch MrExcel Video

Forum statistics

Threads
1,109,258
Messages
5,527,659
Members
409,781
Latest member
Maxcwy2020

This Week's Hot Topics

Top