Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I want to check if the value in the excel activeCell is "Jan" and if this is so I want to check all the columns of the row
Solved by G. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 16/03/2018 - 10:24
HI
User 16/03/2018 - 10:25
ok
Excelchat Expert 16/03/2018 - 10:25
Hi
Excelchat Expert 16/03/2018 - 10:26
Do you wan to just check "jan" in column
User 16/03/2018 - 10:27
yes
Excelchat Expert 16/03/2018 - 10:27
ok
User 16/03/2018 - 10:31
can i write code
Excelchat Expert 16/03/2018 - 10:31
no
Excelchat Expert 16/03/2018 - 10:31
i have create this formula
Excelchat Expert 16/03/2018 - 10:31
=MATCH("jan",1:1,0)
Excelchat Expert 16/03/2018 - 10:32
does this solution is accurate
Excelchat Expert 16/03/2018 - 10:34
Thank you for using GO IT PRO
User 16/03/2018 - 10:34
i want to use VBA for this
User 16/03/2018 - 10:35
because for other columns under Jan i need other checks
Excelchat Expert 16/03/2018 - 10:36
yes
Excelchat Expert 16/03/2018 - 10:36
i think you are right
Excelchat Expert 16/03/2018 - 10:36
but due to policy i am only handle one question per session
Excelchat Expert 16/03/2018 - 10:36
now you have to come back again with VBA specification.
User 16/03/2018 - 10:36
ok thanks
Excelchat Expert 16/03/2018 - 10:37
thank you for using GOT IT PRO

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.