Tables and Vlookup/Index Match

[hmltnangel]

Morning all,

I used to be real good at doing vlookup and Index Match functions within tables. Somehow I have lost my ability to do so and am tearing my hair out. I have had a search but maybe not searching for the right terms. ANy guidance would be useful here.

I have a table in my Workbook called "Roster" which holds every bit of data I can piece together about evry individual in my organisation.

I also have a separate table on another sheet in the workbook, called "terms"

On the "terms table", I have added a blank column. I want this column to lookup the Employee ID of someone in the "Roster" and return a value from another column in the "Roster" Table

If these weren't tables, then Vlookup or Index Match is easy, but as they're tables and im using table references, I must be making a mistake somewhere. Any ideas?

The Vlookup I tried is
=VLOOKUP([Emplid],Roster,Roster[2019 Performance Rating],FALSE)

This returns #n/a

Index Match
=INDEX(Roster,MATCH([Emplid],Roster,0),Roster[2019 Performance Rating])

Again #n/a

WHat silly mistake am I making ?‍

 

[pjmorris]

without checking, but I'd guess that its the third parameter which is the number of the column you want to return. so, perhaps instead of Roster[2019 Performance Rating] you need Range(Roster[#Headers]).find("2019 Performance Rating").column you'll need to adjust for any columns to the left of the EMPLID column.

HTH, at least a bit