|Subject:||Code to write to Index Match intersection|
|Posted by:||L. Howard (lhkitt…@comcast.net)|
|Date:||Mon, 13 Jul 2015|
What would be the code to write to the intersection of the following formula?
Where B1 is a scanned in ID number, like ABC1001 and C1 is the current day Date like 7/13.
I want to put an a number 1 in that intersection. I would want the ability to also enter a string if necessary, so an xyx or a 1)
Somehow I think I should be using FIND or SEARCH, but don't know how to produce a intersection range.