I have recently been asked a question relating data imported from a csv file into Excel worksheet. I want to know name of the cities with lowest and highest revenue. I did some online research and I found out that lookupvalue function can be useful in solving this problem. However, I didn't find any topic pertaining to handling the result of this function when it's a table (multiple value). I appreciate it if you can help me.