Search Array and return column/row data

%3CLINGO-SUB%20id%3D%22lingo-sub-2823041%22%20slang%3D%22en-US%22%3ESearch%20Array%20and%20return%20column%2Frow%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2823041%22%20slang%3D%22en-US%22%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3EI%20want%20to%20search%20the%20array%20for%20a%20value%2C%20have%20the%20array%20evaluate%20the%20number%20and%20return%20a%20value%20equal%20to%20or%20greater%20than%20the%20searched%20value%20and%20get%20the%20row%20and%20column%20information%20of%20the%20intersection%20point.%20See%20the%20array%20below.%20E.G.%20input%2026%2C%20get%2085%20%26amp%3B%20109%20as%20the%20response.%20Thanks%20in%20advance%20for%20any%20help%20you%20can%20provide.%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E88%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E85%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E80%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E75%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E70%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E65%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E68%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%20class%3D%22%22%3E36.7%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E70%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E36.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E80%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E33.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E84%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E31.8%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E34.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E90%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E29.8%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E32.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E95%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E27.9%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E30.6%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E100%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E25.9%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E29.0%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E109%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E22.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E26.5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E29.5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E110%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E21.9%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E26.2%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E29.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E115%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E20.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E24.6%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E27.9%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E120%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E18.6%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E23.0%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E26.5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E125%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E17.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E21.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E25.2%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E130%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E16.0%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E19.5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E23.9%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E134%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E15.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E18.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E22.9%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E25.5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E140%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E13.8%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E16.6%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E21.5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E24.0%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E145%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E13.0%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E15.4%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E20.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E22.9%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E150%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E12.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E14.2%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E19.0%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E21.7%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E158%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E11.0%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E12.7%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E16.4%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E19.9%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E20.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E160%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E10.7%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E12.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E15.7%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E19.5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E20.0%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E165%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E10.2%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E11.5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E14.4%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E18.5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E19.2%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E170%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E9.7%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E10.7%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E13.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E17.4%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E18.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E175%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E9.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E10.0%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E12.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E15.8%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E17.6%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E180%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E8.4%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E9.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E11.0%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E14.2%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E16.8%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E181%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E8.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E9.2%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E10.8%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E13.9%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E16.7%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E15.4%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E190%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E7.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E8.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E9.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E11.6%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E15.5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E14.2%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E195%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E6.7%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E8.0%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E8.7%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E10.6%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E14.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E13.7%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E200%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E7.6%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E8.0%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E9.6%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E12.6%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E13.1%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E202%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E6.5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E7.8%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E9.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E12.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E12.9%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E210%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E7.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E8.0%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E10.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E12.0%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E213%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E6.2%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E7.6%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E9.5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E11.7%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E220%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E6.7%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E8.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E10.9%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E224%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E6.0%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E7.5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E9.9%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E230%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E6.6%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E8.5%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E235%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E5.8%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%20class%3D%22%22%3E7.5%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E240%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E6.5%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E245%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E5.5%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2823041%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2823590%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20Array%20and%20return%20column%2Frow%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2823590%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1178686%22%20target%3D%22_blank%22%3E%40JMBalik%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20please%20explain%20bit%20more%20your%20example.%20Greater%20or%20equal%20to%2026%20is%2026.2.%20It%20gives%2080%20and%20110.%20Please%20see%20attached.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2834085%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20Array%20and%20return%20column%2Frow%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2834085%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20a%20crane%20capacity%20chart.%20In%20many%20occasions%20the%20weight%20if%20a%20lifted%20load%20is%20known.%20The%20%22idea%22%20would%20require%20inputting%20the%20weight%20then%20searching%20multiple%20capacity%20charts%20to%20assist%20in%20selecting%20a%20crane.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2841592%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20Array%20and%20return%20column%2Frow%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2841592%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20example%20you%20sent%20is%20essentially%20what%20I'm%20trying%20to%20accomplish.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

 

 

 

 

 

I want to search the array for a value, have the array evaluate the number and return a value equal to or greater than the searched value and get the row and column information of the intersection point. See the array below. E.G. input 26, get 85 & 109 as the response. Thanks in advance for any help you can provide.

 

88

85

80

75

70

65

68

36.7

 

 

 

 

 

70

36.1

 

 

 

 

 

80

33.1

 

 

 

 

 

84

31.8

34.1

 

 

 

 

90

29.8

32.1

 

 

 

 

95

27.9

30.6

 

 

 

 

100

25.9

29.0

 

 

 

 

109

22.3

26.5

29.5

 

 

 

110

21.9

26.2

29.3

 

 

 

115

20.3

24.6

27.9

 

 

 

120

18.6

23.0

26.5

 

 

 

125

17.3

21.3

25.2

 

 

 

130

16.0

19.5

23.9

 

 

 

134

15.1

18.3

22.9

25.5

 

 

140

13.8

16.6

21.5

24.0

 

 

145

13.0

15.4

20.3

22.9

 

 

150

12.1

14.2

19.0

21.7

 

 

158

11.0

12.7

16.4

19.9

20.3

 

160

10.7

12.3

15.7

19.5

20.0

 

165

10.2

11.5

14.4

18.5

19.2

 

170

9.7

10.7

13.1

17.4

18.3

 

175

9.1

10.0

12.1

15.8

17.6

 

180

8.4

9.3

11.0

14.2

16.8

 

181

8.3

9.2

10.8

13.9

16.7

15.4

190

7.3

8.3

9.3

11.6

15.5

14.2

195

6.7

8.0

8.7

10.6

14.1

13.7

200

 

7.6

8.0

9.6

12.6

13.1

202

 

6.5

7.8

9.3

12.1

12.9

210

 

 

7.1

8.0

10.1

12.0

213

 

 

6.2

7.6

9.5

11.7

220

 

 

 

6.7

8.1

10.9

224

 

 

 

6.0

7.5

9.9

230

 

 

 

 

6.6

8.5

235

 

 

 

 

5.8

7.5

240

 

 

 

 

 

6.5

245

 

 

 

 

 

5.5

 

 

 

 

 

 

 

5 Replies

@JMBalik 

Could you please explain bit more your example. Greater or equal to 26 is 26.2. It gives 80 and 110. Please see attached.

 

@Sergei Baklan 

This is a crane capacity chart. In many occasions the weight if a lifted load is known. The "idea" would require inputting the weight then searching multiple capacity charts to assist in selecting a crane.

 

Thanks

@Sergei Baklan 

 

The example you sent is essentially what I'm trying to accomplish.

 

Thanks for your time.

@Metrojmb 

As variant that could be

=INDEX(rowData, INDEX(  SUMPRODUCT((data=MINIFS(data,data,">=" & M6))*ROW(data))-ROW(data)+1, 1))

for the value in left row and

=INDEX(columnData, INDEX(  SUMPRODUCT((data=MINIFS(data,data,">=" & M6))*COLUMN(data))-COLUMN(data)+1, 1))

for one in columns:

image.png

Thank you, I'll try to decipher your formulas.
I assume rowData refers to the 88, 85, 80, etc. row on the example spread sheet.
columnData refers to the 68, 70, 80, 84 column etc.
The initial "data" in both formulas refers to the actual array as does the second "data"
The third "data" would be a singe cell containing the search term.
If I send you the actual spreadsheet could you help clarify my questions ?

Again, thank you for all your time & help