Hi There, I want to look 1 value and return the multiple results in different rows.

A picture may be worth a thousand words, but it doesn't help much in this case as it doesn't show which rows or columns you are using. Please post a sample workbook, as few people would be prepared to type in that data themselves.

Pete