ExcelBanter - Helpl with formula lookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Helpl with formula lookup (https://www.excelbanter.com/excel-discussion-misc-queries/450629-helpl-formula-lookup.html)

Excel Dumbo

Helpl with formula lookup

1 Attachment(s)

Dear Friends.

Could you please suggest a lookup formula for the attached file ? Thanks heaps

The formula will need to reference Rows 1,3,5,7,9,11,13

Claus Busch

Helpl with formula lookup

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

Excel Dumbo

thanks very much Claus

All times are GMT +1. The time now is 10:54 PM.