Thread: Building a cell RC address from two other cell contents

We have a number as an answer in cell D1. We want that number to be inserted into cell N1 as the row number of a cell address which aready has the column address in it. We will then display the contents of the combined column - row address in Cell N1.

As an example we would like to have something like this in cell N1 =AB7 for column AB and row seven. Then N1 would display the contents of AB7. We need to have the row a variable so that is why we pick it up from D1. The number in D1 is from a combo box and is the "lihked cell".

In ourcase it is AB as the column. We need to transfer the row number from cell D1.

We have tried using AB(D1) and it does not work. If the number in D1 is seven we want the address to be AB7. We have tried a whole lot of other things but they haven't worked yet.

Thanks for any help