I have two ODBC queries reporting back to the same worksheet.

In column A, I have "work Order #", it is formatted as "number", sorted
ascending and has 5 preceeding zeros, thanks to the database that creates
it.... so it looks like this:

0000035681

In column D, I have another query returning "invoice number" and it is also
formatted as number and has THREE preceeding zeros, thanks again to the
second database creating the number....so it looks like this:

00035681

*If* I have a number in column D, Column E will have a date.

I need a formula that looks at a cell in column A, looks for the same number
in column D, if it finds it, report the date it finds right next to it in
column E. It has to be able to ignore the leading zeros (or can someone make
me a macro or VBA thingie to delete the leading zeros?)

There are several thousand work order numbers, but only about 1/2 of those
have a matching invoice numbers (column D). So, column A is maybe 4000 rows,
but columns D&E would fill only about 2500 rows. They do NOT correspond in
any way and the query that reports them is dynamic, so one day cell A55 might
show 0000035681 and the next refresh it might show 0000035686. The same
thing for columns D&E.

Can anyone help?