I am using a lookup formula =lookup(2,1/(hbo!$b34:$h34>0),hbo!$34:$h34) in a summary report to find the current days sales data.
Is there a way to add an additional criteria to this lookup formula to ignore cells with "-" in them? The worksheet my formula is referencing has lot of these (blank cells are filled with "-" because of the formula populating this worksheet) so my lookup formula returns "-" when it finds them instead of the last value in the row it is searching.
Thank you.
Bookmarks