VLOOKUP array function returns the same column

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

Hi murphy,

I've never seen VLOOKUPs used like this...

Just simplify your formula to =VLOOKUP($A3,$B$3:$AJ$19,2,FALSE) then copy this to the other columns, but you have to change 2 to 3, and 4 and 5 separately... and you don't have to array enter...

Hopet this helps...

Hi,

Thanks for the tip. This is how I started to do it. However, I have so many columns in my actual data, and I'm doing this for several different dataframes, that doing so would be extremely tedious. I was hoping to find a way to type one VLOOKUP function into a cell and then drag-paste it across all the cells I wish to fill. Think this is possible?

Thanks again,

Stephen

Great thanks! The COLUMN function made everything work.