Forum Discussion

shlomo's avatar
shlomo
Copper Contributor
Aug 05, 2018

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 number instead of a column heading?

  • shlomo's avatar
    shlomo
    Copper Contributor

    After searching I found a solution here
    Thanks for the stage

Resources