If I understand correctly you want to return an entire row's worth of data. I am a firm believer that anything in Excel is possible and this would be something that sounds like VBA could be the answer. Can you post a sample workbook with the data and a specified cell showing the desired result? I will be happy to see what I can come up with for you.
|