Modification of Existing VLOOKUP function

[meppwc]

The formula below works perfectly but I want to add another condition

=IFERROR(VLOOKUP(A6,'Site Assignments'!A5:G135,6,FALSE),"ASK FOR MORE INFO")

If the cell in column "6" is blank, the formula currently returns "0". I would like it to return blank

Note
The IFERROR portion takes care of the #N/A condition

 

[Aladin Akyurek]

If the formula is expected normally to return text...

=IFERROR(T(VLOOKUP(A6,'Site Assignments'!A5:G135,6,FALSE)),"ASK FOR MORE INFO")


Otherwise:

=IFERROR(IF(VLOOKUP(A6,'Site Assignments'!A5:G135,6,FALSE)="","",VLOOKUP(A6,'Site Assignments'!A5:G135,6,FALSE)),"ASK FOR MORE INFO")

 

[meppwc]

works perfectly Aladin.......thanks so much

 

[Aladin Akyurek]

works perfectly Aladin.......thanks so much

Glad to help. Thanks for providing feedback.