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 underneath the various invoices that were paid.  

My report has about 10,000 lines so manual processing is not an option. Also each payment can have from 1 to 100 bill lines.

I have attached a snippet of the report, basically I am trying to get the payment date highlighted in yellow in column D of the 'Bill Pmt -Cheque' line.  to appear in column L against all 'Bill' lines.

Is this possible??? =)

Bec