$hget(Name,text).N -> would return 3 (if it existed)
This is wrong, when using hash table, you should not take care about the N position of an item in the table, that's not how hash table should be used.
And $hget(table,1).item always returns the last added item, so $hget(Name,text).N would return 1.
If you're (the OP) adding an item with no data, use $hfind as said by Horstl