Excel: delete number in another cell with vlookup function

[welcomemisuki]

As you can see the picture, when I put 4180 in cell D18, the number 200 will be followed in after, the case is same when I put 5680 in cell D23, 200 will be followed in after, but I want to do a case like picture, when I enter “GOOD” cell G21 or “DELETE” cell H21 or any text above the name, then the number will be disappeared, is it possible to do?

I have formula in cell G23 and H23
=IF(G22<>"",VLOOKUP($D23,$K$17:$P$20,ROW(F2),0),"")
=IF(H22<>"",VLOOKUP($D23,$K$17:$P$20,ROW(G2),0),"")

 

[AlanY]

try this

=IF(isblank(G21),"", IF(G22<>"",VLOOKUP($D23,$K$17:$P$20,ROW(F2),0),""))

 

[Fluff]

Cross posted

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please supply all relevant links. Thanks