Hello,
I am parsing an imported PDF, and am using the formula below to find specific words and return cell values nearby. However, this only allows me to lookup a single value in cell AQ4. How can I adjust the formula to allow me to lookup any of the values (with wildcards) in range, say, B2:H2?
Thank you!
I am parsing an imported PDF, and am using the formula below to find specific words and return cell values nearby. However, this only allows me to lookup a single value in cell AQ4. How can I adjust the formula to allow me to lookup any of the values (with wildcards) in range, say, B2:H2?
Excel Formula:
=IF(A4>$P$4,"",INDEX('rawpdf'!$A$2:$H$200,AGGREGATE(15,6,(ROW('rawpdf'!$A$2:$H$200)-ROW('rawpdf'!$A$2)+1)/ISNUMBER(SEARCH("*"&$AQ$4&"*",'rawpdf'!$A$2:$H$200))+2,C4)))
Thank you!