I have a formula that works great for first stage of my project. I am trying to broaden search. I found a formula combo that Brian from Maui wrote and i need help integrating it in to my formula.
Here is my current formula:
=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))
This formula looks at my search input in cell A3(sheet2) and returns all instances of A3 matching the chart i have on Sheet 1. I am trying to now search by more than one input cell.
Brian from Maui suggested someone else use the following for a similar project and i just need help fixing my original formula.
He suggested adding a column in Sheet 1 (Chart) which i've done to columnA : =A2&B2&C2&D2
Then he suggested using this formula in current sheet: =index(Sheet1!A2:A100,MATCH(A3&B3,Sheet1!A2:A100))
Anyone??? Any help would be greatly appreciated
Here is my current formula:
=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))
This formula looks at my search input in cell A3(sheet2) and returns all instances of A3 matching the chart i have on Sheet 1. I am trying to now search by more than one input cell.
Brian from Maui suggested someone else use the following for a similar project and i just need help fixing my original formula.
He suggested adding a column in Sheet 1 (Chart) which i've done to columnA : =A2&B2&C2&D2
Then he suggested using this formula in current sheet: =index(Sheet1!A2:A100,MATCH(A3&B3,Sheet1!A2:A100))
Anyone??? Any help would be greatly appreciated
