Hi,

Am Mon, 2 Feb 2015 07:24:45 +0000 schrieb Excel Dumbo:

|Filename: Query.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=1003|

in B2:
=INDEX('Look UP Data'!$A$1:$AW$2,2,MATCH(A2,'Look UP Data'!$A$1:$AW$1,0))
in C2:
=INDEX('Look UP Data'!$A$3:$AW$4,2,MATCH(A2,'Look UP Data'!$A$3:$AW$3,0))

and copy both formulas down and format your date


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional