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

  • 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

1 Reply

  • shlomo's avatar
    shlomo
    Copper Contributor

    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