JackReacher85
Banned user
- Joined
- Sep 14, 2021
- Messages
- 12
- Office Version
- 2016
- Platform
- Windows
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
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