How to search multiple rows and columns for a string, and if found, return another cell in

I need help searching across multiple rows and columns for a serial number, and then if found, return the delivery date in that row. There are 580 rows, and serial numbers are in columns AD - BQ. The Delivery Date is in column W, and the search criteria is in column AH on another tab. Here is a sample of the data with only 7 of the 40 columns. THANKS!!!

Delivery Date Asset Tag Asset Tag Asset Tag Asset Tag Asset Tag Asset Tag Asset Tag
7/23/10 SRV130279
8/13/10 SRV130741 SRV130742 SRV130738 SRV130739 SRV130740 SRV130737
8/17/10 SRV130756 SRV130757 SRV130758 SRV130759 SRV130753 SRV130754 SRV130755
7/27/10 SRV130476
7/27/10 SRV130468
7/26/10 SRV130472
8/2/10 SRV130539 SRV130540

Will the serial number in question only appear once in the whole table?

If so, try

=SUMPRODUCT(($AD$2:$BQ$1000='another tab'!$AH2)*$W$2:$W$1000)

That worked! THANK YOU!!!

Here is how I used it: =SUMPRODUCT(('Intel Servers Ordered'!$AD$2:$BQ$1000=$AH113)*'Intel Servers Ordered'!$W$2:$W$1000)

You're welcome...

Just keep in mind that formula depends on having only 1 match for AH113 in the whole table (AD2:BQ1000)

If there are multiples, it will have strange results.