Adapting Code to Reference other Cell

[stc60]

Hi, I would appreciate some help adapting the code below. What I want to be able to do is - When the text "Ready" appears in cell K3 on sheet 1. I dont want the data from Sheet1F3 to be displayed. I want this cell to be blank. The text Ready is sent from 3rd party software which I connect excel to. Any help appreciated.



=IF(M9<=Sheet1!$H$3,Sheet1!$F$3,"")

 

[gaz_chops]

Try,

=IF(Sheet1!$K$3="Ready","",IF(M9<=Sheet1!$H$3,Sheet1!$F$3,""))

 

[stc60]

Thanks Gaz, I am thinking about changing another cells code and including (=IF(Sheet1!$K$3="Ready","",) The first line of code below is how the code is at the moment. The 2nd line of code is how I have adapted it to include the new code. Would this be the correct way to do it.

=IFERROR(IF($G$4>Sheet1!$C$2,"",IF(VLOOKUP(B9,Sheet1!E:I,5,0)="","",VLOOKUP(B9,Sheet1!E:I,5,0))),"")

=IFERROR(IF($G$4>Sheet1!$C$2,"", IF(Sheet1!$L$3="Ready","",IF(VLOOKUP(B9,Sheet1!E:I,5,0)="","",VLOOKUP(B9,Sheet1!E:I,5,0))),"")

 

[gaz_chops]

Nearly

=IFERROR(IF($G$4>Sheet1!$C$2,"", IF(Sheet1!$L$3="Ready","",IF(VLOOKUP(B9,Sheet1!E:I,5,0)="","",VLOOKUP(B9,Sheet1!E:I,5,0)))),"")

 

[stc60]

Thanks Gaz, much appreciated.

 

[gaz_chops]

You're welcome.