This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have several columns of data. One is a list of over 1000 names and other associated data. The other is a list of names with a numerical value associated with the names. Not all of the names in the first list are in the second list and vice versa. I am trying to use vlook up to get the the numerical value associated with the second list matched up with the names in the first list. This is the formula I am using VLOOKUP(B2:B1201,F2:G1133,2,FALSE).
Some of the numerical data transfers fine, but for others I am getting the #N/A error. I found that if I copy the name from the second list into the appropriate spot in the first list the error goes away. However with several hundred #N/A errors, this is not feasible. The entries in the two lists look visually identical and I have tried trim and clean to avoid unseen differences.
Any thoughts on what else I might try is appreciated.
Tom
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
If the data you are using is from two different sources, there may be some differences in the way the names are formatted or entered in the two lists. This can cause the VLOOKUP formula to not find a match, even if the names look visually similar.
Hi,
Share the link from where i can download your workbook.
Thank you for being willing to work on this further, but it is really not that important (just creating a workbook for a hobby of mine). I am sure there are people with more pressing needs than mine. Thank you again.