On Sun, 16 Nov 2008 14:34:00 -0800, markwmansell
wrote:

Well I don’t think that’s what I’m after let me try again.

say in sheet 1 you put say 2345 in any cell it auto puts SC in the cell next
to it because is looks look in sheet 2 which will have 2345 in say A1 and in
B1 it will have SC in it am I making any sense. It’s a bit like having a
list of product codes and products on sheet2, when you put a product code in
sheet1 it puts the product name in for you next to the product code.

That's a different description than your first. But we could still use more
data.

Does Sheet2 contain a list of various numbers in column A, and a list of codes
in the adjacent cell in column B?

Do you need to be able to put the 2345 in "any" cell, or will there be specific
cells?

If you have specific cells on Sheet1, then in (all of) the adjacent cell, you
could put a lookup formula: e.g. something like:

b1: =if(a1="","",vlookup(a1,reference_to_table_on_shee t2,2,false))

The reference_to_table_on_sheet2 can be a NAME'd range with workbook scope; or
it can be an address of the type: sheet2!$A$1:$B$100

If you truly mean to be able to put the 2345 in "any" cell, then you will need
to use a VBA event-triggered macro
--ron