Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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

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



Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4

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

Search: