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