ExcelBanter - Find cell of equal value of a range and give result of ajoining co

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Find cell of equal value of a range and give result of ajoining co (https://www.excelbanter.com/excel-programming/306008-find-cell-equal-value-range-give-result-ajoining-co.html)

Word and Excel startup

Find cell of equal value of a range and give result of ajoining co

If cell(a1) = b1:b4 select the ajoining column value.

Frank Kabel

Find cell of equal value of a range and give result of ajoining co

Hi
and what kind of result do you want? the sum?
maybe a worksheet function will do?
=SUMIF(B1:B4,A1,C1:C4)

--
Regards
Frank Kabel
Frankfurt, Germany

Word and Excel startup wrote:
If cell(a1) = b1:b4 select the ajoining column value.

All times are GMT +1. The time now is 07:47 AM.