Code to write to Index Match intersection

Giganews Newsgroups
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)

=INDEX(G5:P13,MATCH(B1,B5:B13,0),MATCH(C1,G2:P2,0))

Somehow I think I should be using FIND or SEARCH, but don't know how to produce a intersection range.

Thanks,
Howard

Replies