Hi All,
I am using a formula to search a saved chart of data to find the number of times an item appears in the chart. I used the following formula to get started...
=IF(ISERROR(INDEX(Chart,SMALL(IF(Fico<=$A$3,ROW(Fico)),ROW(1:1)),5)),"",INDEX(Chart,SMALL(IF(Fico<=$A$3,ROW(Fico)),ROW(1:1)),5))
Chart=whole data array
Fico=Column A of Chart
DocTYpe=Column B of Chart
I used A3 as input to find number times of occurance and list column E of chart for each occurance. It works great.
Here's my question...I really want this to be a search engine for the number of times my input boxes (A3 and B3) both occur at the same time in the Chart. Example: A3=620 and B3=SIVA, i want to print out the data in column 5 of chart for all matches of 620 to Fico and SIVA to DocType.
Anyone have an idea of how to integrate AND or another way to get the same results???
I am using a formula to search a saved chart of data to find the number of times an item appears in the chart. I used the following formula to get started...
=IF(ISERROR(INDEX(Chart,SMALL(IF(Fico<=$A$3,ROW(Fico)),ROW(1:1)),5)),"",INDEX(Chart,SMALL(IF(Fico<=$A$3,ROW(Fico)),ROW(1:1)),5))
Chart=whole data array
Fico=Column A of Chart
DocTYpe=Column B of Chart
I used A3 as input to find number times of occurance and list column E of chart for each occurance. It works great.
Here's my question...I really want this to be a search engine for the number of times my input boxes (A3 and B3) both occur at the same time in the Chart. Example: A3=620 and B3=SIVA, i want to print out the data in column 5 of chart for all matches of 620 to Fico and SIVA to DocType.
Anyone have an idea of how to integrate AND or another way to get the same results???