Forum Discussion
AlyssaCorazzini
Oct 07, 2021Copper Contributor
Formula Help Needed!
I want the cells in column N to equal the value in cell: J2 if cells in column H equal "1", J3 if cells in column H equal "2", J4 if cells in column H equal "3", J5 if cells in column H equal "4", or J6 if cells in column H equal "5".
I made column H a drop-down with value options of 1, 2, 3, 4, 5.
Cells J2:J6 will have $ figures entered.
Can it be done?
- tiptonsacoraCopper Contributor
Works
- Detlef_LewinSilver Contributor
=INDEX(H2:H6,H9)