IF Formula help

[JackReacher85]

Hi guys,

Im having some difficulty with an IF formula ive gotten so far in making it work but need more help, so the formula i have is this

=IF(EXACT(J16,"C0"),Sheet1!A36,"")

What this does it it looks in cell J16 if it finds C0 it then returns the value from Sheet1 Cell A36. The complication to this is i have VBA code that is allowing Cell J16 to have multiple selections in a drop down list and as you may have guessed when i select another option from the list the formula returns nothing so if i select C0 and also 50 XS the formula doesnt show anything. So what i need is the formula to look only for the item i want it to and to ignore anything else that is selected in the cell so that the cell returns what i need and displays it at all times.

Appreciate your help with this, its battering my brain somewhat

 

[Anthony47]

Could you show which area some of the possible values in J16?

In the meantime try using

=IF(ISERROR(FIND("C0",J16)),"",Sheet1!A36)