HLOOKUP problems

A

AMaleThing

I'm having trouble with my HLOOKUP.

=HLOOKUP(E7, 'DATA'!C2:X62, 5, FALSE)

The lookup_value (E7) is a reference to a date. The date format is
yyyy/mm/dd which is determind by the table_array.

I have changed the date by cell-formatting it so it appears 2008/06/23
(the cell is a a formula). This returns #N/A

When the lookup_value cell (E7) a direct reference to the lookup table
(='DATA'!C2) it returns the correct value.

Both methods appear as "2008/06/23".

Why when i type in a date (2008/06/23) does the HLOOKUP not return a
value?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top