Vlookup was working, now have Err:504

[NorthernClimate]

basic calcsheet, 2 Tabs (Tab1 (WorkPlan) has cells to enter a name / Tab2 (RATES) has 2 columns A=Name B=Rate sorted ascending) Currently only 9 names & rates, but will add more as necessary.

=VLOOKUP($B11,PersonnelNames[#all],2,0)

I think I’m missing the correct reference to the RATES Tab2, the range of sorted names/rates I have defined and named PersonnelNames.

I hope someone can help me with the correct syntax & reference to get this spreadsheet working properly, be much appreciated.

[NorthernClimate]

I figured it out all by myself, yes it was the references and syntax.

NEW → =VLOOKUP($B9,$RATES.$A$1:$B$9,2)

I am very happy with this spreadsheet, it should get lots of use by my co-workers.