Hi,
So I have a worksheet with a bunch of data and I want a formula that goes through and searches for values based on what is in Column E. Basically, Column E has a list of brands (lets just say Widgets, Fidgets and Gidgets). I want the formula to go through Column E and looks for when Column E says Widgets, then goes to column T and reports the corresponding value. So if E1-E15 are Fidgets, it wouldnt do anything, but then E16 has a "Widget" value with T16 being $1,000, I would want it to report the $1,000 from T16, and then as I drag the formula down, say the next time Widget is in Column E is in Row 22, to report the Row 22, and so forth.
What would be the best way to go about designing this?
Would it be easier to have a formula that first went through the worksheet and then pulled out all the Widget values and placed them in a different worksheet and then just do a simple "=" and drag down? or is there a way to do this in 1 shot?
So I have a worksheet with a bunch of data and I want a formula that goes through and searches for values based on what is in Column E. Basically, Column E has a list of brands (lets just say Widgets, Fidgets and Gidgets). I want the formula to go through Column E and looks for when Column E says Widgets, then goes to column T and reports the corresponding value. So if E1-E15 are Fidgets, it wouldnt do anything, but then E16 has a "Widget" value with T16 being $1,000, I would want it to report the $1,000 from T16, and then as I drag the formula down, say the next time Widget is in Column E is in Row 22, to report the Row 22, and so forth.
What would be the best way to go about designing this?
Would it be easier to have a formula that first went through the worksheet and then pulled out all the Widget values and placed them in a different worksheet and then just do a simple "=" and drag down? or is there a way to do this in 1 shot?
