My HLookUp won't work

**dominicb** · 05-20-2008, 06:02 AM

Hi all

Feeling sheepish. Having a bad day and can't see past this (what should be a) really simple question.

I have a spreadsheet and I'm trying to put a HLOOKUP formula in cell AH :
=HLOOKUP("April",Input,2)
For some reason it's returning a #N/A error.
If I change range T4:AE4 from month names to numbers, and then change my HLOOKUP formula to :
=HLOOKUP(4,Input,2)
then it works perfectly.

But I don't want numbers. I want month names. What am I doing wrong??

DominicB

**EdMac** · 05-20-2008, 06:24 AM

I did a mock up of your scenario and had problems unless I entered "false" as the final parameter - have you tried that?

**Domenic** · 05-20-2008, 06:26 AM

Since the range lookup is omitted and by default set to 1 or TRUE, the lookup range needs to be sorted in ascending order. Since this is probably not the case and you're likely looking for an exact match, try setting the range lookup to 0 or FALSE.

Hope this helps!

**dominicb** · 05-20-2008, 07:15 AM

Hi guys

Originally Posted by Domenic

try setting the range lookup to 0 or FALSE

Originally Posted by EdMac

unless I entered "false" as the final parameter - have you tried that?

I really thought I'd tried that. Honest

Perhaps my Excel was broke! It's OK now though.

EdMac, sorry you had to try and set up a mock up - I actually had a test sheet prepared to upload but forgot to attach it. Like I said - bad day all round really ...

Thanks for your help guys.

DominicB