you can still use table names in vlookups, and it will still not solve your prob... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

princeb on Aug 28, 2016 | parent | context | favorite | on: Is Microsoft Excel an Adequate Statistics Package?

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 on Aug 28, 2016 [–]

You can use either index/match as avs733 suggested, or alternatively:

    =VLOOKUP(value, Sometable, MATCH("Column2", Sometable[#Headers]))

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact