If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 news 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 news 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to set a formula to count the product appear how manytime | AMY | Worksheet Functions | 3 | March 21st, 2005 09:49 AM |
can't reinstall office xp pro after deleting from windows xp syste | dana | Setup, Installing & Configuration | 1 | August 5th, 2004 06:32 PM |
can't reinstall office xp pro after deleting from windows xp syste | mkskyflyer | Setup, Installing & Configuration | 1 | August 5th, 2004 05:39 AM |
Upgrade 03 Trial to Full | Tom | Publisher | 2 | June 4th, 2004 12:18 AM |
Cummaltive/Summarised Item total on a different product vlookup, depending on the description on the operation | John Colling | Worksheet Functions | 2 | February 21st, 2004 03:44 PM |