3 ms·
you can still use table names in vlookups, and it will still not solve your problem because vlookups do not work by table headers but by column numbers
by princeb 10y ago
you can still use table names in vlookups, and it will still not solve your problem because vlookups do not work by table headers but by column numbers
- viraptor 10y agoYou can use either index/match as avs733 suggested, or alternatively: =VLOOKUP(value, Sometable, MATCH("Column2", Sometable[#Headers]))