• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF Blank

S

Shabbo

Member
Dear SIr,

=IFERROR(LOOKUP(1,MATCH("*"&$AK$1:$AK$38&"*",F13,),$AL$1:$AL$38),"ADVANCE A/C")

This Formula I write in C column based on F column I want to add one more thing that is IF F COLUMN IS BLANK THEN C COLUMN SHOULD BE BLANK AS WELL.

Please advice.
 
Hi,

You can use a leading IF to check if column F is blank:
=IF(F1="","",IFERROR(LOOKUP(1,MATCH("*"&$AK$1:$AK$38&"*",F13,),$AL$1:$AL$38),"ADVANCE A/C"))
Bold part updated

Adjust the cell reference to your need.

Regards,
 
Dear Sir,
Its not working, even if F column is Blank its shows Advance only but I want C column Blank if F column is blank.
 
Shabbo said:
Dear Sir,
Its not working, even if F column is Blank its shows Advance only but I want C column Blank if F column is blank.
Click to expand...
Ok, what do you mean by column F? is it a single cell like F1 or it is a range like F1:F10 ?

It will be difficult to guess without having your file, can you please upload?

Regards,

P.S:
I Just reached the 1st milestone :)
 
Shabbo said:
Dear Sir,

Please find attached herewith.
Click to expand...
Thanks for the file.

I said in my 1st post, "Adjust the cell reference to your need"
F1 is your heading, your data starts from cell F2.

So you just need to replace F1 with F2:
=IF(F2="","",IFERROR(LOOKUP(1,MATCH("*"&$AB$1:$AB$1&"*",F2,),$AC$1:$AC$4),"ADVANCE A/C"))

I didn't check the whole formula, see if it works.

I'll be back tomorrow.

Regards,
 
Shabbo said:
No sir, Its not working it shows Advance if its blank.
Click to expand...
I am not sure what else you are looking for.
See the green cells with same formula, IF column F is blank then column C will also blank.

Regards,
 

Attachments

  • IFBLANK.xlsx
    24 KB · Views: 0
You must log in or register to reply here.
Back
Top