4 ms·
> your vlookups, hlookups will not change your column numbers If you're not using tables yet, you should. They solve that problem easily, and make addressing m
by viraptor 10y ago
> your vlookups, hlookups will not change your column numbers
If you're not using tables yet, you should. They solve that problem easily, and make addressing more explicit (relative to the table name rather than the sheet)
- princeb 10y agoyou 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]))