Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Helpl with formula lookup
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
|
|||
|
|||
thanks very much Claus
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Utilizing a RANDBETWEEN() formula within a LOOKUP formula | Excel Discussion (Misc queries) | |||
Lookup Formula | Excel Worksheet Functions | |||
Lookup formula? | Excel Worksheet Functions | |||
lookup formula | Excel Worksheet Functions | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions |