| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find cell of equal value of a range and give result of ajoining co
If cell(a1) = b1:b4 select the ajoining column value.
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup does not give the result in the cell even though it is | Excel Worksheet Functions | |||
| Find first cell in a row not equal to | Excel Worksheet Functions | |||
| Trying to find Matches and Give a Result | Excel Worksheet Functions | |||
| How do I get a cell to give a result based on the month we are in? | Excel Worksheet Functions | |||
| entering a26-02 into a cell give strange result | Excel Discussion (Misc queries) | |||
Linear Mode
