– Vlookup Invalid Cell Reference Error If error checker is on, then press the button that displays next error and clicks Show Calculation Steps if it emerges After that go for aMar 17, 21 · What is XLOOKUP?Aug 08, 14 · Good morning, I have this formula in cell K28 on one worksheet in Excel 07 =VLOOKUP(K26,DataTables!K2K31,3,TRUE) K26 refers to a cell containing an individual's name (which can and will vary) I K28, I want to have an email address The "DataTables" worksheet contains the following info How To Vlookup To Return Blank Or Specific Value Instead Of 0 Or N A In Excel Excel vlookup invalid name error