I'm working with a print/merge program where I have an excel spreadsheet with a list of names and electronic signatures and I'm trying to use a lookup function to extract the signature for the chosen name.
First I should explain that these signatures are actually scanned and then put into a word document. I cropped them and put them into the Excel spreadsheet.
I have a list of the names in C2 thru C40 and the corresponding pasted signatures in D2 thru D40. The user types in the requested name in B2.
Therefore I used the following Lookup
=VLOOKUP(B2,$C$2:$D$40,2,FALSE)
However, instead of bringing back the electronic signature, it brings back a 0. Is there something I can do to correct this?
I appreciate your time and anticiapted help. Thanks, Terry