Rob,
It could help a lot if you provide the information about that VLookup solution - what does it do, where did you get it from and what exactly doesn't work.
It's really hard to look for a black cat in a black room with no lights on, especially when there is no cat at all.