Forum Discussion
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...
=INDEX(H2:H6,H9)