Use Master List to put names in mulitple worksheets

I am very new to VBA. I want to create a "Master List" with names and be able to insert the names from the list into multiple spreadsheets using a formula/VBA. The Master list will be the names of candidates and I want a name to be place into cell B1 of each worksheet, i.e. Worksheet 1, cell B1, name from master list Duck, Donald; Worksheet 2, cell B1, name from master list Mouse, Mickey, etc. Is this possible? Thanks.

Please Login or Register  to view this content.

$A$1 = the value you are searching for
MasterList!$A$1:$B$4 = the data set / range that holds the data you are searching for and want to return. the first column of this data range MUST be the same as the value you are searching for.
2 = the column number in the range selected that you want to return a value.
0 = whether or not you want an Approximate or an Exact match. may also be set as TRUE or FALSE

i.e.

=vlookup("Green", $A$1:$C$3,2,0)

Please Login or Register  to view this content.

in this example you are looking for the value of "Green" and want to return whatever is in column 2 and don't need an exact match. In this case you would return "Block". if you had put 3 instead of 2 in your formula, you would return "Square"