Lookup Formula

Hi

Not sure if this is even possible but i want to look up a date in a range of cells, both vertical and horizontal then return a data in a cell in that row

for example:

in cell A2 on another sheet i have 06/08, i want to find this in the below range A:C and then bring back whatever is in column D of this row, so for this example it would be 08/08

A B C D
1 01/08 02/08 03/08 04/08
2 05/08 06/08 07/08 08/08
3 09/08 10/08 11/08 12/08

any help would be appreciated.

thanks
Sharon