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 |
#2
|
|||
|
|||
VLOOKUP with PRODUCT functionality?
Hi!
Try this entered as an array using the key combo of CTRL,SHIFT,ENTER: =PRODUCT(IF(A1:A6="X",B1:B6)) Biff "J" wrote in message ... 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 |
#3
|
|||
|
|||
VLOOKUP with PRODUCT functionality?
thanks Biff! that's perfect!
cheers ~J "Biff" wrote: Hi! Try this entered as an array using the key combo of CTRL,SHIFT,ENTER: =PRODUCT(IF(A1:A6="X",B1:B6)) Biff "J" wrote in message ... 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 |
Reply |
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 |