Forum Discussion

AlyssaCorazzini's avatar
AlyssaCorazzini
Copper Contributor
Oct 07, 2021

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?

Resources