# Excel - IF Function Problem - Expert Solution

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

need help in this =IF(C2="","",IF(ISBLANK(IF(C2="yes",HLOOKUP(VALUE(MONTH(A2) & "/" & DAY(A2) & "/" & YEAR(A2)),Sheet2!\$B\$1:\$AA\$1000,2,FALSE),IF(C2="no",HLOOKUP(VALUE(MONTH(A2) & "/" & DAY(A2) & "/" & YEAR(A2)),Sheet2!\$B\$1:\$AA\$1000,3,FALSE),""))),"NOT YET",IF(C2="yes",HLOOKUP(VALUE(MONTH(A2) & "/" & DAY(A2) & "/" & YEAR(A2)),Sheet2!\$B\$1:\$AA\$1000,2,FALSE),IF(C2="no",HLOOKUP(VALUE(MONTH(A2) & "/" & DAY(A2) & "/" & YEAR(A2)),Sheet2!\$B\$1:\$AA\$1000,3,FALSE),""))))
Solved by V. Q. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 15/12/2017 - 02:32
thank you and welcome for selecting the excel chat
Excelchat Expert 15/12/2017 - 02:32
User 15/12/2017 - 02:33
I want to understand the value function
Excelchat Expert 15/12/2017 - 02:34
The Microsoft Excel VALUE function converts a text value that represents a number to a number.
Excelchat Expert 15/12/2017 - 02:34
The syntax for the VALUE function in Microsoft Excel is: VALUE( text )
User 15/12/2017 - 02:34
yes
Excelchat Expert 15/12/2017 - 02:35
Parameters or Arguments text The text value to convert to a number. If text is not a number, the VALUE function will return #VALUE!.
User 15/12/2017 - 02:35
can you please give me an example?
Excelchat Expert 15/12/2017 - 02:37
for example please see the shared sheet
Excelchat Expert 15/12/2017 - 02:39
if we write the text then it shows the error and
Excelchat Expert 15/12/2017 - 02:40
VALUE function converts a text value that represents a number to a number
Excelchat Expert 15/12/2017 - 02:40
are you understand ?
User 15/12/2017 - 02:40
yes
User 15/12/2017 - 02:40
yes thanks
Excelchat Expert 15/12/2017 - 02:41
do you have any other doubt?
User 15/12/2017 - 02:41
no thanks
Excelchat Expert 15/12/2017 - 02:41
can i close this session?
User 15/12/2017 - 02:41
yes
Excelchat Expert 15/12/2017 - 02:42
bye sir
Excelchat Expert 15/12/2017 - 02:42
thanks for selecting the got it pro
Excelchat Expert 15/12/2017 - 02:42
help me sir by rating 5 star
User 15/12/2017 - 02:42
yes sure

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.