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.