Lookup - Look Up (not down) rows until it reaches a certain specified text?

Hi! I have a report that I need to show the date the bill was paid on the same line. (QB wont spit out the report like this of course!) Currently, the report shows the bill payment on one line, and...