TVProducer
New Member
- Joined
- Dec 29, 2017
- Messages
- 3
Hello All,
So i have spent an hour researching this but it seems as though i cannot get the formula right.
My task is to take a reference cell (user input cell) and compare it with an array of data, when it matches something, it returns a value, else, it checks another array. see below example
<tbody>
</tbody>
so if someone enters into the user input cell B757 i want it to check the first array of values (2nd column), if it finds it return "Category D Aircraft", if not, it will check the next array, then return "Category E Aircraft", else "No Match."
The Formula i was using is IF(ISNA(MATCH(A1,B1:B3,0)),"CATEGORY D AIRCRAFT",IF(ISNA(MATCH(A1,C1:C3,0)),"CATEGORY E AIRCRAFT", "NO MATCH"))
Another thing that bugged me is that i have to put all values in quotes because they are strings. I want the user to not have to put anything in quotations when they put in an aircraft model.
Thanks for the help!
So i have spent an hour researching this but it seems as though i cannot get the formula right.
My task is to take a reference cell (user input cell) and compare it with an array of data, when it matches something, it returns a value, else, it checks another array. see below example
USER INPUT CELL | "B757" | "E120" | |
<tbody> </tbody> | "B190" | ||
<tbody> </tbody> | "C650" |
<tbody>
</tbody>
so if someone enters into the user input cell B757 i want it to check the first array of values (2nd column), if it finds it return "Category D Aircraft", if not, it will check the next array, then return "Category E Aircraft", else "No Match."
The Formula i was using is IF(ISNA(MATCH(A1,B1:B3,0)),"CATEGORY D AIRCRAFT",IF(ISNA(MATCH(A1,C1:C3,0)),"CATEGORY E AIRCRAFT", "NO MATCH"))
Another thing that bugged me is that i have to put all values in quotes because they are strings. I want the user to not have to put anything in quotations when they put in an aircraft model.
Thanks for the help!