VLOOKUP ?... I just need to return a name from a code name when i input a code name

Dell55

=VLOOKUP([Student Code]@row, {Student List All}, {Student Name List}, false)

I made a function to return a kids name from a code name and im not sure why i cant get it to work.

I made a sheet with a student name list next to a column with the student code and referenced it for this formula

It worked when I made it for just one or 2 specific names but i cant get it to work for the list

I keep getting #invalad data type

SmartLew

Hey Dell,

Your formula needs to reference the whole lookup table, with the Student code on the far left, and then the number of the column you want to fetch.

e.g if you want the value in the second column;

=VLOOKUP([Student Code]@row, {Student List All}, 2, false)

If your data is not formatted perfectly left to right, an INDEX/MATCH may work better for you!

=INDEX(column withe the value you want),match(student code@row,column with the student code in),0)

Let me know how you get on!

SmartLew

Hey Dell,

Your formula needs to reference the whole lookup table, with the Student code on the far left, and then the number of the column you want to fetch.

e.g if you want the value in the second column;

=VLOOKUP([Student Code]@row, {Student List All}, 2, false)

If your data is not formatted perfectly left to right, an INDEX/MATCH may work better for you!

=INDEX(column withe the value you want),match(student code@row,column with the student code in),0)

Let me know how you get on!

Andrée Starå

Hi @Dell55

I hope you're well and safe!

Read too quickly!

Be safe and have a fantastic week!

Best,

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

Dell55

@SmartLew

YES! I just switched the order of my reference sheet rows and now ... Works perfectly!!!

THANKS!