On Wed, 2/8/17, storeythomas725 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Formula help needed
To: excel-macros@googlegroups.com
Date: Wednesday, February 8, 2017, 8:30 PM
On Wed, 2/8/17, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Formula help needed
To: excel-macros@googlegroups.com
Date: Wednesday, February 8, 2017, 3:01 PM
On
On Wed, 2/8/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ Formula help needed
To: "excel-macros@googlegroups.com"
Date: Wednesday, February 8, 2017, 2:29 PM
The
Match() function will return the relative column for the
dat
The Match() function will return the relative column for the date matching the
header.So: Your array of data is in E1:AI1 and if you're looking for the date
in cell C1, you would use:MATCH(C$1,$E$1:$AI$1)(the "$" will be necessary for
when you copy the formulas)
In this case, the function return
Dear Friends,
I am stuck while preparing a dashboard. I need auto pickup of data based (in
cell highlighted yellow) on model & date from the right side. If I change date
(from 31-Jan-17 to 27-Jan-17) the data should change..
I think Index/Match with vlookup should work.. but not sure how to use