Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
INDEX MATCH Functions in LibreCalc (Excel) - Non unique valuesreturn wrong index result | Excel Worksheet Functions | |||
Create Bar code Sheet w/lookups, index/match | Excel Worksheet Functions | |||
VBA code for INDEX MATCH Functions | Excel Programming | |||
Error finding match looking for intersection | Excel Programming | |||
Match data to find intersection | Excel Programming |