VLOOKUPto copy vertex info over to the edge worksheet. Rather than having to deal with obtuse indexes and the like you can refer to the columns and worksheets by name. For example, instead of something like this as your formula
=VLOOKUP(A3,Vertices!1:1048576,29,FALSE)you can use this instead
=VLOOKUP([@[Vertex 1]],Vertices,COLUMN(Vertices[Pub Year]),FALSE)This uses NodeXL's named worksheets and columns instead. Also, counting offsets can get pretty tedious, especially with how NodeXL hides columns and how many of them there are. By using the
COLUMNfunction you don't have to!