Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP with PRODUCT functionality?
i am wondering if it is possible to do a vlookup() type search for multiple
instances of something, and then multiply the results together. for example, i want to search two columns for a value/string "X" and multiply the numbers corresponding to it together: X 0.04 Q 0.08 R 0.45 X 0.33 T 0.01 X 0.94 so the desired result of this would give me 0.0124 given by multiplying all the X's together ( 0.04*0.33*0.94). if this doesnt make sense, please let me know and i'll try to clarify. thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Rows/Columns for Copying Formulas | Excel Discussion (Misc queries) | |||
Percentages | Charts and Charting in Excel | |||
How to set a formula to count the product appear how manytime | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Which function(s)? | Excel Worksheet Functions |