Hello,

I have a dataframe with rownames that I wish to match up with a longer list of names. There are also several columns associated with the dataframe that I wish to also match up with the long list. This will result in a larger dataframe where the rownames in the list that are not found in the dataframe will simply take zero values.

Example Picture:
Attachment 193782

It seems like I should be able to do this with an array VLOOKUP function as follows:

{=VLOOKUP($A3,$B$3:$AJ$19,{2,3,4,5},FALSE)}

However, when I copy and paste this to adjacent columns, it returns the values from column 2 into all new columns.

Example:
Attachment 193785

Any thoughts?

Thank you