Hello friends, let me explain the situation -

If Cell A4= "Cricket", then cell A5= "Welcome to Cricket Match"
If Cell A4 = "Foortball", then cell A5 = "Welcome to Football match"
If Cell A4 = "Tenis", Then cell A5 = "Welcome to Tenis Match"
If cell A4 = " Hockey", then cell A5 = "Welcome to Hockey Match"
and so on and on.

That is in a single cell, output is required to be displayed according to condition it satisfies.

With "If " function only, I am just able to check two conditions. but I wana to check 5-8 conditions for a single cell.

I hope query has been sufficiently explained, if you know the way out kindly help.


Regards,
kamal