I need a formula to pull a column of data from sheet 1 to sheet 2 when a certain text is entered into a cell.
If b2 on sheet 2 = "AA" i would like A2:10 to return the information from sheet 1 A2:10 and if "BB" then A2:10 then return sheet 1 B2:10 and so forth. I will need to be able to return data from at least ten different columns on sheet 1 but only one at a time.
Ant help would be greatly appreciated and thank you in advance