How to return a blank cell based on if then criteria

[azucar360]

I have the following formula: =IF($G11=$B11,$B$6,IF($G11=$C11,$C$6,IF($G11=$D11,$D$6,IF($G11=$E11,$E$6,IF($G11=$F11,$F$6)))))

If G11 is blank, then I want it show return an empty cell.
How do I correct my formula to show that?

[Jonmo1]

Try

=IF(G11="","",INDEX($B$6:$F$6,MATCH($G11,$B$11:$F$11,0)))

[azucar360]

it returned #N/A

[Jonmo1]

To avoid the resulting error when the value of G11 is NOT blank AND G11 doesn't equal any of the values in B11 to F11,
Try

=IFERROR(IF(G11="","",INDEX($B$6:$F$6,MATCH($G11,$B$11:$F$11,0))),"")

[azucar360]

OMG! You totally ROCK! That worked! THANK YOOOOOOU!!!

[Jonmo1]

You're welcome, thanks for the feedback.