Search column, return values in adjacent column?

**HELPME13** · 09-29-2010, 04:07 PM

Is there a formula to search an entire column, say Column C for the value 'x' (literally the letter x) and return the value in the B column of the same row?

Search for the letter x in column c, when you find the x, return the corresponding column B value. If multiple X's are found, the values in B are added.

Any help would be appreciated.

(the letter X could also be replaced with a number like 1, 2, 3, 4....10 etc.)

**DonkeyOte** · 09-29-2010, 05:52 PM

Originally Posted by HELPME13

If multiple X's are found, the values in B are added.

It's not clear if values in B are numeric or not - ie whether you mean to aggregate or if text strings - concatenate.

Assuming numbers - see SUMIF

=SUMIF(C:C,A1,B:B)

where A1 holds criteria be it "X" or a number.

If B holds text values (to be concatenated) then things are much messier - the approach you adopt will largely depend on volume of data etc...