View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Olle Nyström Olle Nyström is offline
external usenet poster
 
Posts: 3
Default "Look up" with multiple hits?

There is a range of "look up" formulas that finds a value in one column and
delivers a value from a different column in the same row. But all of them
seemes to be designed to find one specific answer.

I have a column where I mark differnt types of rowes. Let's say there are
ALFA-types and BETA-types. I want Excel to find all the rowes marked ALFA in
column number one (they are not sorted), and add their values from another
column.

This seemes to be so basic that I guess I'm missing something obvious.
Please help me out.

Cheers

/Olle