Is there a more efficient way to do this?

[c3rberu5]

Hello All,

I have a worksheet which is as follows.

Data validation dropdown > fills in X in a table

1. Dropdown list is (A,B,C,D,E)

2. The selection then adds an "X" into a separate table as per below, here an "E'' was chosen.

E	D	C	B	A
X

<tbody>
</tbody>

As per the above I used A2=IF($E$124="E","X","") to fill in B2 I would have to change the formula to =IF($E$124="D","X","") and so on.

More info:

• The drop downs are placed vertically in merged cells at the bottom of the sheet starting at E124
• The legend for E-A also appears vertically.
• The questions appear every 3 rows so I cannot just copy the function the cells without changing the reference.
• I cannot change the formatting only add functions as I did not create the sheet

Is there an easier function to use or an easier way to copy this over to the other cells without manually having to change the logical test each time? Maybe a lookup or some sort of nested function to make this all easier?

Thanks in advance.

 

[Smitty]

Welcome to the Board!

Please continue in your Original Thread.