Can't seem to get vlookup to work

Antje B.

I have a master sheet and a secondary sheet. In the master sheet I put in all my data such as the “Name of the Project” and “Asset Type”. This master sheet is already pretty complex and has too many columns already.

In the secondary sheet I want to keep track of a different set of data related to these projects but some of the columns are repeating, such as the “Asset Type”. I would like this “Asset Type” automatically be filled in from the main sheet based on the name of the project.

I tried vlookup but somehow I can’t get this formula to work. The issue might be that neither one of these columns are in the first space and that seems to be a requirement for vlookup.

Any suggestions how I can automatically fill in my “Asset Type” cells in the secondary sheet? is there a workaround with vlookup where i don't need the columns be in the first column space or is there a different formula that would do the same?

Thanks in advance!

Angie

Andrée Starå

Hi @Antje B.

I’d recommend using an INDEX/MATCH combination instead because then you don’t need to worry about the position of the columns at all.

Make sense?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Antje B.

Thanks Andree. I actually managed to figure it out and got vlookup to work.

https://community.smartsheet.com/discussion/comment/263604#Comment_263604

Andrée Starå

@Antje B.

Excellent! Glad you got it working!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!