**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 E. U. in 12 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
15/12/2017 - 01:50

thank you and welcome for selecting got it pro

Excelchat Expert
15/12/2017 - 01:50

please tell me sir how may i help you?

User
15/12/2017 - 01:50

hi

User
15/12/2017 - 01:51

I need to understand the formula of Hlookup

Excelchat Expert
15/12/2017 - 01:51

yes sir

Excelchat Expert
15/12/2017 - 01:53

The Microsoft Excel HLOOKUP function performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index_number

Excelchat Expert
15/12/2017 - 01:53

The syntax for the HLOOKUP function in Microsoft Excel is:
HLOOKUP( value, table, index_number, [approximate_match] )

User
15/12/2017 - 01:53

yes

User
15/12/2017 - 01:53

go ahead please

Excelchat Expert
15/12/2017 - 01:54

Parameters or Arguments
value
The value to search for in the first row of the table.

Excelchat Expert
15/12/2017 - 01:55

Two or more rows of data that is sorted in ascending order.
index_number
The row number in table from which the matching value must be returned. The first row is 1.

Excelchat Expert
15/12/2017 - 01:55

value
The value to search for in the first row of the table

Excelchat Expert
15/12/2017 - 01:55

table
Two or more rows of data that is sorted in ascending order.

Excelchat Expert
15/12/2017 - 01:56

index_number
The row number in table from which the matching value must be returned. The first row is 1.

Excelchat Expert
15/12/2017 - 01:56

approximate_match
Optional. Enter FALSE to find an exact match. Enter TRUE to find an approximate match. If this parameter is omitted, TRUE is the default.

Excelchat Expert
15/12/2017 - 01:56

now we see the real example

Excelchat Expert
15/12/2017 - 01:58

in displayed sheet i applied the Hlookup formula

Excelchat Expert
15/12/2017 - 01:58

the lookup value is in cell G2 and applied the formula in cell H2

Excelchat Expert
15/12/2017 - 01:59

so as per function if we write any value in cell G2

Excelchat Expert
15/12/2017 - 01:59

this value takes the data from the row no 2 and match with put value in cell g2

Excelchat Expert
15/12/2017 - 02:00

is it make sence sir?

User
15/12/2017 - 02:00

yes

User
15/12/2017 - 02:00

thank you

Excelchat Expert
15/12/2017 - 02:00

any other help do you need?

User
15/12/2017 - 02:00

no

User
15/12/2017 - 02:00

thank you

Excelchat Expert
15/12/2017 - 02:01

can i close this session?

User
15/12/2017 - 02:01

yes you can

Excelchat Expert
15/12/2017 - 02:01

help me by rating 5 star

User
15/12/2017 - 02:02

bye

Excelchat Expert
15/12/2017 - 02:02

bye sir

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