Hi,

I am having a little trouble finding out how to link two columns for a drop down list.

I have Column A1 - A20 populated which links to a drop down list in cell C1. I want cell C2 to be populated with the contents of the corresponding B column.

For example, if in the drop down list, Cell A2 is selected, i want cell C2 to be populated with the contents of B2. If A5 is selected it should be B5.

I have tried using a number of IF commands, (=IF(C1=A1,B1,IF(C1=A2, B2, IF(C1=A3,b3... ETC...

But this can only handle up to A8 (8 IF commands) before the formula stops working.

Does anyone know of a way that i can link cells A and B to show that whichever number A is used, the correct B cell will be displayed?

Thanks