- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.programming
- 2015 July
- Code to write to Index Match intersection

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

- Re: Code to write to Index Match intersection posted by Claus Busch on Tue, 14 Jul 2015