| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column Lookup?
I have reference data in Column "$Q$3:$Q$502" of "sheet1". For all cells in
the reference column that contain "yes", I would like to average quantity in cells for Column $S$3:$S$502 respectively. So if it finds 3 in column Q with "Yes" (2,3,4) , it will return the number 3. -- Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup looks to the prior column if zero appears in the lookup col | Excel Discussion (Misc queries) | |||
| LookUp Function with Two Column Search Returning One Column Value | Excel Worksheet Functions | |||
| lookup text in one column, count in another column | Excel Worksheet Functions | |||
| Lookup in one column, and return value from another column | Excel Worksheet Functions | |||
| Calculating totals in a column based on a lookup in another column | Excel Worksheet Functions | |||
Threaded Mode
