Forum Discussion
shlomo
Aug 05, 2018Copper Contributor
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
- shlomoCopper 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