I am having issues with this VLOOKUP. It is on the tab ' Instructor Pay Data', column 'Z' Total Pay. =IFERROR(IF(W2<>"0",VLOOKUP(Y2,'Master Pay Rates'!$A$11:$C$2002,3,FALSE),"-"),"-"). The tab 'Master Pay Rates' I am sure is setup correctly, and the data validation for these names is on the tab 'Instructor and Location Payrate' columns 'Z' and 'AA'
Any help on this is appreciated.