Hi

You may have seen my earlier post about invoice numbers. Well I almost have it cracked I just need to copy some data. My layout is similar to this;

A B

1 X Y
2 PK00001


3 PK00002
4 PK00003
5 PK00004
6 PK00005
7 PK00006

So, for example, if X (A1) is 1, then I would like the value from A2 (PK00001) to be displayed in B1.

Likewise if A1 is 2, then PK00002 and so on.

Is there a formula to do this?

Thanks