View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KUMPFfrog KUMPFfrog is offline
external usenet poster
 
Posts: 38
Default match, lookup two column data

I want to perform a calculation base off criteria from two columns.

ex:
A B
1 apples 222
2 oranges 156
3 apples 789
4 apples 222
5 oranges 789

if all the 'apples' in column 'A' have the same corrisponding value in
column 'B' then multipy the value in 'B' times some number. In this example,
ALL the 'apples' do not have 'B' values that match so it will return "Varies".

Thanks