Hi,
we know that the vlookup formula look this way :
vlookup(lookup value;table array;col_index_num;range lookup)
if in a table i have 50 columns, shall i count all the columns to see the nbr of the column from which i need to return the value accordingly ,starting from the first column of the table or is there any inteligent formula which by clicking on the needed column itself will exempt me from counting ?!
2) where is the mistake in formula R3 which shall return the same answer as P3?
I appreciate your help , thank you
we know that the vlookup formula look this way :
vlookup(lookup value;table array;col_index_num;range lookup)
if in a table i have 50 columns, shall i count all the columns to see the nbr of the column from which i need to return the value accordingly ,starting from the first column of the table or is there any inteligent formula which by clicking on the needed column itself will exempt me from counting ?!
2) where is the mistake in formula R3 which shall return the same answer as P3?
I appreciate your help , thank you