Forum Discussion
Kyle_Thompson
Aug 22, 2023Copper Contributor
Help with cross referencing using XMATCH and INDEX.
The task I'm trying to accomplish is to create an automatic lookup method for conduit sizing. I'm referencing the tables in Annex C of the 2023 NEC, and I've copied one portion into a spreadsheet whi...
OliverScheurich
Aug 23, 2023Gold Contributor
=INDEX($B$2:$G$2,SMALL(IF(OFFSET($B$3:$G$3,MATCH(C14,$A$4:$A$10,0),0)>C15,COLUMN($A$1:$F$1)),1))
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.