excellent tips very helpful. hope to learn more from this site.
Share:
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)," ").
