Vlookup the result of a function

[Godders199]

Good afternoon, trying To set up a spreadsheet that populates the name of the person who opened it.
we are using a function =displayusername() Which works and gives me the staff number. However when I do a vlookup on the staff number I just get #n/a.
I know the vlookup is correct as if I delete the function and type in the staff number it works correctly.
i Have never tried to search the result of a function before, so am wondering if I need to do something different , from =vlookup(c1,hierarchy!d:i,6,false)? . Any help appreciated.

 

[Fluff]

Sounds as though either the function is returning a text rather than a number & your lookup table has numbers, or vice-versa

 

[Godders199]

Sounds as though either the function is returning a text rather than a number & your lookup table has numbers, or vice-versa

Thanks, the cells is formatted as “general” , is there a way to check it is returning a text value? Or add something to the function to ensure it returns a number?
the function code is.
set objNetwork = CreateObject(“Wscript.Network”)
DisplayUserName = objNetwork.UserName.

thanks

 

[Fluff]

You can check if it's a number or not by putting this in another cell

=isnumber(C1)

change the C1 to look at the cell with the function.

 

[Godders199]

You can check if it's a number or not by putting this in another cell

=isnumber(C1)

change the C1 to look at the cell with the function.

Thank you much appreciated, can see it is a text value now.

 

[Fluff]

Ok, if it needs to be a number, then you can multiply the function result by 1