# Excel - IF Function Problem - Expert Solution

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

need help =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 G. S. in 9 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 16/12/2017 - 02:06
welcome sir and thanks for selecting got it pro
Excelchat Expert 16/12/2017 - 02:06
User 16/12/2017 - 02:07
hi
User 16/12/2017 - 02:07
hi
User 16/12/2017 - 02:08
Excelchat Expert 16/12/2017 - 02:08
yes
Excelchat Expert 16/12/2017 - 02:09
ISBLANK function can be used to check for blank or null values
Excelchat Expert 16/12/2017 - 02:09
The syntax for the ISBLANK function in Microsoft Excel is: ISBLANK( value )
Excelchat Expert 16/12/2017 - 02:10
Parameters or Arguments are
User 16/12/2017 - 02:10
yes
User 16/12/2017 - 02:10
so it is used for check the value in cell is blank or not?
Excelchat Expert 16/12/2017 - 02:10
yes sir
Excelchat Expert 16/12/2017 - 02:10
value The value that you want to test. If value is blank, this function will return TRUE. If value is not blank, the function will return FALSE.
Excelchat Expert 16/12/2017 - 02:11
wait i will give an example
Excelchat Expert 16/12/2017 - 02:11
=ISBLANK(A1) is formula
Excelchat Expert 16/12/2017 - 02:13
The ISBLANK function returns TRUE if the value is blank.
Excelchat Expert 16/12/2017 - 02:13
The ISBLANK function returns FALSE if the value is not blank.
Excelchat Expert 16/12/2017 - 02:13
are you understand
User 16/12/2017 - 02:13
wait
User 16/12/2017 - 02:13
I will check
User 16/12/2017 - 02:14
yes thank you
Excelchat Expert 16/12/2017 - 02:14
?any other help do you need
Excelchat Expert 16/12/2017 - 02:14
?
User 16/12/2017 - 02:14
no this is enough very well thanks
Excelchat Expert 16/12/2017 - 02:14
ok can i close this session?
User 16/12/2017 - 02:14
yes
Excelchat Expert 16/12/2017 - 02:15

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.