Previous Topic Next Topic

HLOOK UP HELP!!! PLEASE !!!

Closed
adit - May 7, 2010 at 01:25 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 7, 2010 at 03:47 PM
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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 7, 2010 at 03:47 PM
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