View Single Post
  #4   Report Post  
puck1263 puck1263 is offline
Junior Member
 
Posts: 20
Default

Thanks. Look ups are working now. I didn't realize about including the whole array.

What would be a better way to handle the "blanks" (or "" as it is now) in column H?

When I put the formula above in I3, it is returning a value, even though H3 is truly blank. I don't know what it's looking up. Any ideas?

Last edited by puck1263 : June 21st 12 at 10:34 PM