# Combined use of ISBLANK, VLOOKUP, IFERROR

##### New Member
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,

#### Attachments

• ISBLANK.JPG
31.8 KB · Views: 7

### 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
=IF(C3="","",IFERROR(VLOOKUP(A3,F3:G5,2,FALSE),""))

#### CA_Punit

##### Well-known Member
=IFERROR(VLOOKUP(IF(C3<>"",A3,""),F:G,2,0),"")

##### New Member
=IF(C3="","",IFERROR(VLOOKUP(A3,F3:G5,2,FALSE),""))
Thanks. I will try this.

##### New Member
=IFERROR(VLOOKUP(IF(C3<>"",A3,""),F:G,2,0),"")
Thanks for the solution.

#### Fluff

##### MrExcel MVP, Moderator
Glad we could help & thanks for the feedback.

Replies
28
Views
273
Replies
7
Views
106
Replies
0
Views
62
Replies
9
Views
131
Replies
4
Views
51