HLOOK UP HELP!!! PLEASE !!!

Closed
adit - May 7, 2010 at 01:25 PM
rizvisa1 Posts 4479 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 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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