Hey all,

I have read through some related posts but still don't understand how to do this.

I would like to input data in column AZ
and for each cell in AZ i would like it to vlookup the value in column S in the same row for the lookup array in another worksheet

I would like th macro go on if it hits error, vlookup only if AZ is empty and stop with column S is empty

Plz help