Hi All,
I need a function which will give me the data from other column based on a criteria.
Example:
Say in Column A i have different IDs and in Column B i have the records. Column A may contain duplicate IDs also. Now i want a function which will give me the result in Column C. Say in Cell A1 the ID is ABC123 and in Coumn B the corresponding record is PQR123.
Again in Cell A5 i have the same ID ABC123 and in Column B the corresponding record is XYZ345.
Now i want a function which will return me unique record from Column B for ID ABC123.
When i use vlookup funtion it is giving me the same result PQR123 both the time.

Is there any function which will give me PQR123 for the first search on my ID and XYZ345 for second search?