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
please tell me how may i help you?
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.
