PDA

View Full Version : Index Match Match



NonVBer
06-26-2014, 07:42 AM
I am a seriously VBA challenged user, as you can see by my username.

I am attempting to create VB code that will create an Index Match Match formula for use in any cell, referencing any range in a workbook (used numerous times in the workbook). The column match will contain a date value.

For example, a simple example of the formula might translate to:

=index($b$2:$f$5,match($a$1,$a$2:$a$5,0),match(DateValue,$b$1:$f$1,0))

The function would need to allow for any value/range to be input for any of the arguments. It is very important that the "DateValue" variable be translated in date format to match the correct columns.

Any suggestions to create this function that will allow me to enter something similar to "=IndMatMat" as the function name in a cell and then the 5 required arguments?

Thanks!

NonVBer
06-26-2014, 11:07 AM
Wow. No one has an idea?...