Ok so on Sheet2 I would like to have the entire row that is in Sheet1. I would only like to see stuff that has the same "d1" description. However is D1 is the same and B1 is the same that will not work. I would like to have D1 the same and B1 with different fields. For example CWHL 2004-9 A5 is in D1 and TAHO and JVBM are different in B1. I would like to have the entire row show up for TAHO and JVBM in Sheet 2. Does that make sense?
Ok, but what formula did you use? this is all dummy data I need the formula for future use?