Wednesday, May 12, 2010

Better vlookup for edges in NodeXL

I recently was using NodeXL and had to use VLOOKUP to 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
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 COLUMN function you don't have to!

No comments:

Post a Comment