Thread: Look up
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
forevercali forevercali is offline
external usenet poster
 
Posts: 3
Default Look up

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