When using

`VLOOKUP`

in Excel/NodeXL, you may often get zeros when looking for text and it isn't found. In many cases you may want an empty string instead. For example

=VLOOKUP([@[Vertex 2]],Vertices,COLUMN(Vertices[Flags]),FALSE)

returns 0 when the

`Flags`

column for

`Vertex 2`

in the

`Vertices`

worksheet is empty. Our tools work better with empty cells. So rather than write something gross like

=IF(VLOOKUP([@[Vertex 2]],Vertices,COLUMN(Vertices[Flags]),FALSE)=0,"",VLOOKUP([@[Vertex 2]],Vertices,COLUMN(Vertices[Flags]),FALSE))

that does the search twice, just use the

`T`

function that automatically turns it into text.

=T(VLOOKUP([@[Vertex 2]],Vertices,COLUMN(Vertices[Flags]),FALSE))