Getting error #value

Hi,
If the cell '$b$1' = Std. 9 A or Std. 9 B' then the cell should show 'Hindi1' else 'Hindi2'. The formula is giving error #value.

Please Login or Register  to view this content.

Any help will be appreciated.

Thanking you,

Try this instead:

Formula:

Please Login or Register  to view this content.

Hi Glenn,
Thank you for correction. It's partially working. If there is 'Std. 9 A or Std. 9 B' on information sheet $b$1 then the cell should display 'Hindi1' else 'Hindi2'. Now for Std. 9 B it is showing 'Hindi2' instead of 'Hindi1'.

Std. 9 A: Hindi1
Std. 9 B: Hindi1
Else: Hindi2

Thanking you.

Sorry... Clumsy copying by me..

Formula:

Please Login or Register  to view this content.

Hi Glenn,
Thank you. Now it's working fine.

Thank you.

You're welcome.. and apologies for mucking it up first time...

Dear Glenn,
Please don't mind.

You have solved my problem and I appreciate you for the same.

Thank you and have a nice day.