by richard

excellent tips very helpful. hope to learn more from this site.


when using vlookup you can use names and indirect function in order to refer ,show and edit the values in an array more easily. E.g. =iferror(vlookup(A1,indirect(name),false)," ").

hope this would help..

Click here to post comments

Join in and write your own page! It's easy to do. How? Simply click here to return to 7-week Challenge.