HoldemHank
New Member
- Joined
- Sep 10, 2011
- Messages
- 4
=IF(OR(AND(Sheet1!B2:B100={"Carl Edwards"}),AND(Sheet1!C2:C100={"3"})),Sheet1!D2,"Wrong")
The above works great for a single row. I need data from column D in the same row that was true on sheet1 copied over to sheet2.
Something like this
=IF(OR(AND(Sheet1!B2:B100={"A"}),AND(Sheet1!C2:C100={"3"})),Sheet1!D%Row Number that was true%,"Wrong")
The above works great for a single row. I need data from column D in the same row that was true on sheet1 copied over to sheet2.
Something like this
=IF(OR(AND(Sheet1!B2:B100={"A"}),AND(Sheet1!C2:C100={"3"})),Sheet1!D%Row Number that was true%,"Wrong")
