Linking cells

[nikki115]

Hi

Is it possible in excel that if i eneter a value in cell for example

Cell A Cell B
Juke Box

and next time when i enter value (Juke) in a cell, value (Box) comes up automatically in the next cell as shown above.
i would realy appreciate ur help as i need to enter lots of data which is going to repeat in other work books and its is in nos so i dont want to enter that data again and again and with no mistake in it.

[EdMac]

if the relationships are always the same, you could do it by creating a table of the corresponding values and use VLOOKUP to complete the second cell.

Ed

[nikki115]

Thanks for ur reply yes the relationship is going to be the same all the time could u please tell me the steps how to do it in detail many thanks.

[EdMac]

Hi Nikki,

Example attached with some guidance on how to do it.

Hope it helps,

Ed

[nikki115]

Hi ed,
Thanks for ur reply i m just gonna try this one.

[nikki115]

hi Ed,
i have tried it worked only within the same workbook i wanted to have this effect even if i enter in another workbook anytime i mean i just want to fix this relationship forever so when ever i type it in any workbook in excel it appears automatically e-g,

TO1234 this is our product code and its origenal part is ASD456 and i wanna fix this relationship that whenever i enter our product code TO1234 the origenal part no come up in the next cell automatically.

do u think its possible in excel.
many thanks for ur help.

[EdMac]

Hi Nikki,

Lookup can work across workbooks provided you provide the filepath as part of the lookup formula.

So if you had another workbook named Parts, and the table was called partstable the formula would be something like

Please Login or Register  to view this content.

Ed