Combined use of ISBLANK, VLOOKUP, IFERROR

[PRADEEPSWALSE]

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
3	weweh
Sheet1

Cell Formulas
Range	Formula
B3	B3	=IFERROR(VLOOKUP(A3,F3:G5,2,FALSE),"")

Regards,
Pradeep

 

[Fluff]

How about
=IF(C3="","",IFERROR(VLOOKUP(A3,F3:G5,2,FALSE),""))

 

[CA_Punit]

=IFERROR(VLOOKUP(IF(C3<>"",A3,""),F:G,2,0),"")

 

[PRADEEPSWALSE]

How about
=IF(C3="","",IFERROR(VLOOKUP(A3,F3:G5,2,FALSE),""))

Thanks. I will try this.

 

[PRADEEPSWALSE]

=IFERROR(VLOOKUP(IF(C3<>"",A3,""),F:G,2,0),"")

Thanks for the solution.

 

[Fluff]

Glad we could help & thanks for the feedback.