Input value A1 in C13, then display value B1 in D13 etc

[poggster]

Hello! I am stuck, and hopefully there is an easy way out of this!

I have two columns with data that I want to «link» to 2 other columns. Macro or other way?

(Row A and B "linked")

Row A	Row B	etc	Row H	Row I
121	2455
331	2331		112	4433
112	4433		121	2455
etc	etc		121	2455

<tbody>
</tbody>

If I input value 121 somewhere (dynamically) in Row H (i.e. H3 and H4), then it will display 2455 in Row I (I3 and I4). So goes for the other values in Row A. I enter value 112 (value A3) in H2, then it displays value B3 in I2 etc.

If I change the first line in row B from 2455 to 2255, it will show 2255 in Row I (like the above example; I3 and I4).

Please. Any help or pointers much appreciated!

 

[henrik2h]

Use vlookup

 

[poggster]

Thanks....i actually used INDEX instead.