Forum Discussion

shlomo's avatar
shlomo
Copper Contributor
Aug 05, 2018
Solved

Use formulas with tables

Why this formula   =VLOOKUP(B2,table1[#All],table1[[#Headers],[column3]],FALSE) Where I want to specify the column header as an operator (col_index_num) Not working? Do I have to use a column ...
  • shlomo's avatar
    Aug 05, 2018

    After searching I found a solution https://answers.microsoft.com/en-us/office/forum/office_2003-excel/vlookup-use-column-heading-to-specify-column-from/91248f79-211b-497a-9aab-8b34db70d337?db=5
    Thanks for the stage

Resources