In a recently solved post, daddylonglegs gave the following code as a solution:
I understand Replace, but I don't understand the Lookup function. Could someone describe to me how this works?
Please Login or Register to view this content.
Specifically, I'm curious how this works to solve the problem specified in the solved post.