Assuming your cell that you're driving it from is B2, and the data you're after is in row 2 of Sheet 1, then this should work:
Copy that down and you'll get the rows below to come over as well.Code:=IF($B$2="A",Sheet2!B4,IF($B$2="B",Sheet2!C4,Sheet2!C4))
Bookmarks