Mesh two tables of data


February 20th, 2011 by admin admin

Question: 
How can i “mesh” two tables of data?  Each block of data has a common column with the person’s last name.  When I sort, however, there are missing names in the smaller block of data.  I want excel to link or mesh the two blocks.

Answer:
You can apply the VLOOKUP formula on the bigger table for those fields you want to combine. If the formula find the last name (common field), they would return the values found in the smaller table. If not, you will get a #N/A error which is an indication that the value is not available in the small table. Remember to set the last parameter to FALSE.

Leave a Reply

You must be logged in to post a comment.

s2Member®