Hello. Please help to modify the following formula so that I can search along column A. The formula has a condition that cell C5 matches A17 I want to do a search from A17 to A63
Code:
Sheet1!C$5=Sheet2!A17:A63
VBA Code:
=IFERROR(INDEX((Sheet1!$C$9:$G$63;Sheet1!$H$9:$M$63);MATCH(Sheet2!$T$1;Sheet1!$B$9:$B$63;0);MATCH(Sheet2!T$2;Sheet1!$H$8:$M$8;0);(IF(Sheet1!C$5=Sheet2!A17;IF(Sheet2!T$3=Sheet1!C7;1;IF(Sheet2!T$3=Sheet1!H7;2;3)))));"")