Excel 2007 : vlookup to specific range

i have code here that lookup Sheet1 col.A[no specific range], the lookup matrix is in sheet2 col A:B [with specific range].

heres the code

Please Login or Register  to view this content.

but my problem is how can i run this automatically and stop to where colA sheet1 has no value already.?

*//blankcell must also equal to "blank"
kindly see attachment.


Thanks

Hi JieJenn

its not working thou.


Thanks.

thanks its working.
btw can i add 1 column. i need to have a specific range to stop the lookup.

let me say

3 columns in sheet1
in col A data is 1-15
in col B data is 1-9[with data] 10-15[blank data], blank data is equal to blank.
how can you manage to lookup all data in colum B. 1-15[no specific range].

sheet2 [table matrix, still the same].

Thanks.

i will look up the all col B in sheet 1 and the answers in col C.

how will i do that.

thanks.

Thanks JieJenn

i already get it.

Hi

how can i look up if my table matrix is in the other server. using your code above.

thanks.

heres my code,

Please Login or Register  to view this content.

but it gives me error.


Thanks.