Forum Discussion

Copper Contributor

Dec 18, 2020

Excel 365 - Vlookup issue

safikul6190 _ While using Excel 365, wherein during V lookup function, the col_index_num / table array details are not displayed as it used to be while using the previous version of Excel

Formulas and Functions

Copper Contributor

Dec 18, 2020

can anyone help with this issue

SergeiBaklan
Diamond Contributor
Dec 19, 2020
safikul6190

Could you please be more concrete, what exactly is wrong? Small sample file could help.
- safikul6190
  Copper Contributor
  Dec 20, 2020
  SergeiBaklan, when you apply the function vlookup=(lookup_value,table_array,col_index_num,[range_lookup]), post selection the table_array or the data you are able to see the col_index_num field next to the highlighted area in the previous version which you enter so that you can get the value from the column you are looking for. However, in Excel 365 the selection field is not highlighted and you have to manually count the column or have to enter number value at the top of the table to recognize the column you need the value from. This seems to an issue with Excel 365 and not with any file.
  - SergeiBaklan
    Diamond Contributor
    Dec 22, 2020
    safikul6190
    
    In support to previous posts, with XLOOKUP it's as easy as
    
    =XLOOKUP(date, Table[Date], XLOOKUP(shopName, Table[#Headers],Table), "no such")
    
    if shopName is one of columns name from which you'd like to return the value.

Resources