I am doing a Lookup array. I am getting everything except one item

=LOOKUP(L17,L565:M569)

My array:
Dry/Dry 1
Dry 2
Dry/Wet 3
Wet 4
Wet/Wet 5

I am getting the correct information for all of my catagories except Dry. It
will show a N/A. I am not sure why this is happening. Any input to this
insanity will help?

Thank

For LOOKUP the data has to be sorted ascending, so Dry should occur above
Dry/Dry

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"forevercali" wrote in message
...
I am doing a Lookup array. I am getting everything except one item

=LOOKUP(L17,L565:M569)

My array:
Dry/Dry 1
Dry 2
Dry/Wet 3
Wet 4
Wet/Wet 5

I am getting the correct information for all of my catagories except Dry.
It
will show a N/A. I am not sure why this is happening. Any input to this
insanity will help?

Thank

With a LOOKUP function, the lookup value needs to be alphabetical.
Alphabetizing your list would be DRY ... DRY/DRY ... DRY/WET ... WET ...
WET/WET

You could use VLOOKUP with exact match.
=VLOOKUP(L17,L565:M569,2,FALSE)

Hope this helps.
--
John C


"forevercali" wrote:

I am doing a Lookup array. I am getting everything except one item

=LOOKUP(L17,L565:M569)

My array:
Dry/Dry 1
Dry 2
Dry/Wet 3
Wet 4
Wet/Wet 5

I am getting the correct information for all of my catagories except Dry. It
will show a N/A. I am not sure why this is happening. Any input to this
insanity will help?

Thank

Why are you using LOOKUP?

If you want what's in M565:M569
with the lookup value matched in L565:L569
use


=VLOOKUP(L17,L565:M569,2,0)

which is an exact lookup

it's just pure luck that you get some of the lookups correct
using your formula



--


Regards,


Peo Sjoblom

"forevercali" wrote in message
...
I am doing a Lookup array. I am getting everything except one item

=LOOKUP(L17,L565:M569)

My array:
Dry/Dry 1
Dry 2
Dry/Wet 3
Wet 4
Wet/Wet 5

I am getting the correct information for all of my catagories except Dry.
It
will show a N/A. I am not sure why this is happening. Any input to this
insanity will help?

Thank