Hello!
If I have this list:
<tbody>
</tbody>
In another sheet I have a cell where I want to populate 1 of 3 options based on whether the value in an adjacent cell is a part of the range I have defined in the list above.
The 3 options would be "Alpha" "Bravo" and "Charlie"
So, if these are my cells:
<tbody>
</tbody>
If the adjacent cell value would have been 'A1' then the cell to the right should report "Alpha" (same for 'C1' it should report "Charlie" etc)
I am thinking I need a hybrid IF(MATCH( formula but can't seem to find anything that works.
Any help would be appreciated!
Mark
If I have this list:
A1 |
A2 |
A3 |
A4 |
A5 |
B1 |
B2 |
B3 |
B4 |
B5 |
B6 |
B7 |
B8 |
C1 |
C2 |
<tbody>
</tbody>
In another sheet I have a cell where I want to populate 1 of 3 options based on whether the value in an adjacent cell is a part of the range I have defined in the list above.
The 3 options would be "Alpha" "Bravo" and "Charlie"
So, if these are my cells:
This is the value of the 'adjacent cell' = B7 | I need a formula to report "Bravo" because B7 is a part of the "Bravo" range (range defined by me in formula) |
<tbody>
</tbody>
If the adjacent cell value would have been 'A1' then the cell to the right should report "Alpha" (same for 'C1' it should report "Charlie" etc)
I am thinking I need a hybrid IF(MATCH( formula but can't seem to find anything that works.
Any help would be appreciated!
Mark