how to create a macro that finds the appropriate data

September 23, 2018 at 19:43:28
Specs: PC
I need a macro that will reference a "date" cell, HLOOKUP that date in a table, and return several of those cells back into the new tab.

Or I need an HLOOKUP formula that will not merely return a single cell, but a tables work of cells. A6:C22 for example.


See More: how to create a macro that finds the appropriate data

Reply ↓  Report •

#1
September 24, 2018 at 07:02:14
Not a 100% sure what you are asking so lets me ask a few questions...

             A           B            C                 
1       01/01/2018   02/01/2018  01/01/2018
2             4            2             8
3             3            7             6
 

So if take the example above, say we were looking for date "01/01/2018" across "A1:C1"

01/01/2018 appears in both A1 and C1, therefore you wish to return the value within a particular row

for example 4 and 8 (if row 2 is chosen) or 3 and 6 (if row 3 is chosen)

Is this correct?

message edited by AlwaysWillingToLearn


Reply ↓  Report •
Related Solutions


Ask Question