Dec 18 2020 01:26 AM
@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
Dec 19 2020 02:58 AM
Could you please be more concrete, what exactly is wrong? Small sample file could help.
Dec 20 2020 12:05 AM
@Sergei Baklan, 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.
Dec 20 2020 12:35 AM
Dec 20 2020 10:03 AM
If you are an Excel 365 user, why not switch to XLOOKUP? It is better than VLOOKUP in almost all respects.
Dec 22 2020 12:30 PM
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.