With Vlookup it has to be a sorted alphabaticly list.
plus the fact that they want it in VB, and no formulas
waht so ever on teh sheet
-----Original Message-----
Hi
why is a formula no alternative for you (e.g. VLOOKUP)?
Otherwise you have to use an event procedure (the
worksheet_change event)

-----Original Message-----
I need a VB script for the next example. (no formula)
In column A1/A4 of Sheet1 i have values, say 1,2,3,4.
In column B1/B4 of sheet1 i have values, say A,B,C,D.
In column A1/A4 of sheet2 i have the same values as in
column A of sheet1
In column B1/B4 of sheet2 i have the values, say
AA,BB,CC,DD
When i change for example the value "1" in column A of
sheet1, i need automaticely the coresponding value from
the cel from Column B on sheet2, in column B on sheet1.
Thamk you so much


.

.