# Excel - IF Function Problem - Expert Solution

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

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

## Click here to get your free Excelchat help session

Trusted by people who work at