| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup where column data does not match | Excel Worksheet Functions | |||
| Index/Match - Lookup based on multiple column criteria | Excel Worksheet Functions | |||
| 2 column lookup - match to date range | Excel Worksheet Functions | |||
| The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
| Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
Threaded Mode
