Hello everybody \r\n \r\nSometimes, I have to struggle with my data a lot. Currently I am trying to extract data from a number of selective columns of the source sheet into a target sheet. \r\n \r\nVLOOKUP function helps me retrieve data from a single column only. I intend to retrive data from more than one column, based on the same Lookup Value, in one go. \r\n \r\nI will apprciate any help - doing it programmatically or using just a formula.