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
please tell me how can i help you?
User
16/12/2017 - 02:07
hi
User
16/12/2017 - 02:07
hi
User
16/12/2017 - 02:08
can you please tell me about the isblank function
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
please help me by rating 5 star
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.