INDEX MATCH RETURN DIFFERENT VALUE IF value exists

Hi guys

Is there a way to instruct excel to return a different value if the value being looked up exists when using index match?

=IFNA(INDEX('Easy Eating Cous Cous 1805'!$D$16:$D$5718,MATCH('Flavoured Cous Cous 1854'!B16,'Easy Eating Cous Cous 1805'!$D$16:$D$5718,FALSE)),"Not in 1805")

VALUE LOOKED UP IS:

31057

VALUE returned IS:

31057


^^ How can I change the value returned to say: 'Exists'

thanks,

R.

you could just use a countif()


=IFNA(INDEX('Easy Eating Cous Cous 1805'!$D$16:$D$5718,MATCH('Flavoured Cous Cous 1854'!B16,'Easy Eating Cous Cous 1805'!$D$16:$D$5718,FALSE)),"Not in 1805")

How about

=If( Countif('Easy Eating Cous Cous 1805'!$D$16:$D$5718,'Flavoured Cous Cous 1854'!B16)=0,"Not in 1805","Exists")

A sample sheet would help here

The forum does allow for spreadsheets to be uploaded direct to the forum -

Please see the Yellow Banner at the top of the page explaining how to attach a sample spreadsheet

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Here are the instructions, found at the top of the page again

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

thank you Wayne this works for now!

you are welcome