Nested IF, IFS or OR's

[Smeggy]

Hi All,
I'm trying to resolve a nested IF in excel, or IFS. Which ever is easiest. I'm trying to get the following idea to work:
IFS(Sheet1B8=Sheet2A3,C23,Sheet1B8=Sheet2A4,C23,Sheet1B8=Sheet2A5,C23,Sheet1B8=Sheet2A6,C22,Sheet1B8=Sheet2A7,C22,Sheet1B8=Sheet2A8,C22,Sheet1B8=Sheet2A9,C22,Sheet1B8=Sheet2A9,C22,Sheet1B8=Sheet2A10,C22)
However this fails every time.

In Sheet1B8 i have a drop down list
In Sheet2A3 etc is a list of text (names)
In C23 is some text
The following works =IF('Order Sheet'!B8='Information Sheet'!A3,C23) but when i add IFS or IF(or) it fails

The following is an exampl of it failing
=IFS('Order Sheet'!B8='Information Sheet'!A3,C23,'Order Sheet'!B8='Information Sheet'!A4,C23,"No Value")

 

[cerfani]

I never used IFS before but this is the idea...

=IF(test,result,IF(test2,result2,IF(test3,result3,fail)))

Change...

IFS(Sheet1B8=Sheet2A3,C23,Sheet1B8=Sheet2A4,C23,Sheet1B8=Sheet2A5,C23,Sheet1B8=Sheet2A6,C22,Sheet1B8=Sheet2A7,C22,Sheet1 B8=Sheet2A8,C22,Sheet1B8=Sheet2A9,C22,Sheet1B8=Sheet2A9,C22,Sheet1B8=Sheet2A10,C22)

to...

IF(Sheet1!B8=Sheet2!A3,C23,IF(Sheet1!B8=Sheet2!A4,C23,IF(Sheet1!B8=Sheet2!A5,C23,IF(Sheet1!B8=Sheet2!A6,C22,IF(Sheet1!B8=Sheet2!A7,C22,IF(Sheet1!B8=Sheet2!A8,C22,IF(Sheet1!B8=Sheet2!A9,C22,IF(Sheet1!B8=Sheet2!A9,C22,IF(Sheet1!B8=Sheet2!A10,C22)))))))))

 

[Smeggy]

Fabulous - Thank you cerfani, works like a dream