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

### 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
=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
0
Views
26
Replies
10
Views
136
Replies
15
Views
216
Replies
5
Views
56
Replies
3
Views
67