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
|