Hi,
Generally if we use vlookup function,it will pull only the first data if we have same data that appears multiple times.
Eg Check
123 1
231 2
123 34
1456 45
456 10
If we vlookup for 123,it will pull only 1 and it will not show 34.is there anyway to pull both 1 and 34 that is...