Hello Sir,
I applied vlookup multiple rows with the same lookup value with index farmulla, my same lookup values are more than 3 i.e. if it if 10, then it shows only 1st value as a result and then #num error. rest of 9 values are not shows. i copied the farmulla 10 times... but results not came.
I attached a sample file, where i want subdealers of rohit enterprises, to be shown 1 by 1
pls help me with the same