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: 7

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Fluff

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

Watch MrExcel Video

Forum statistics

Threads
1,119,087
Messages
5,576,035
Members
412,694
Latest member
Deaf1Too
Top