HLOOK UP HELP!!! PLEASE !!!

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Does any one know why my HLOOKUP formula that I have looks up the answer even though i give a wrong value.

When i enter the date it looks up the value. but when i enter the date that is not
inside the range of the table it still gives an answer.

my formula looks like this
IF(ISNA(HLOOKUP(B2,$B$3:$CA$22,14)),"",(HLOOKUP(B2,$B$3:$CA$22,14)))

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You are missing the fourth parameter which says that find exact match

IF(ISNA(HLOOKUP(B2,$B$3:$CA$22,14, FALSE)),"",(HLOOKUP(B2,$B$3:$CA$22,14, FALSE)))
0