**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.*