VALUES CORRESPONDING FROM SHEET1 / SHEET2

[R.Deurs]

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

 

[Frank Kabel]

Hi
why is a formula no alternative for you (e.g. VLOOKUP)?
Otherwise you have to use an event procedure (the
worksheet_change event)

 

[Guest]

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

 

[Tom Ogilvy]

Vlookup doesn't require that the information be sorted if you are looking
for an exact match.