Substring / Wildcard / Regex matching has a lot of flexibility in Value Lookup, but other than that I think it was just to re-name the process as something more recognizable to new users coming from Excel. I have seen a ton of forum posts asking how to do vlookups or Value Lookups. Probably just wanted the node to be more intuitive to excel users.
I rarely bother to write something myself when @takbb has likely already written a full length article as a forum post that I can just drop in as a link!
