Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum a row of multiple vlookups
I have a row of mixed data that gets used elsewhere with a vlookup table. some cells are blank. I would like to place a sum of all the vlookups into a single cell. I have tried using the sumproduct (isnumber(match(index...... method but it doesn't seem to create two arrays of the same size. here is a example of tables layout: _Row_of_Data_ A B C D E F G H I J L 1 s m l m s l s _vlookup_table_ A B C D 1 s 100 2 m 1000 3 l 10000 So for Row 1 I need the following result where the values in Row 1 are used to in a vlookup to get the value from column D of the vlookup table: 100+0+1000+10000+0+1000+100+10000+0+100+0=22300 thnx -- jtgostars ------------------------------------------------------------------------ jtgostars's Profile: http://www.excelforum.com/member.php...o&userid=29543 View this thread: http://www.excelforum.com/showthread...hreadid=492443 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum a row of multiple vlookups
Try...
=SUMPRODUCT(SUMIF(N1:N3,A1:L1,O1:O3)) ....where N1:O3 contains your lookup table. Hope this helps! In article , jtgostars wrote: I have a row of mixed data that gets used elsewhere with a vlookup table. some cells are blank. I would like to place a sum of all the vlookups into a single cell. I have tried using the sumproduct (isnumber(match(index...... method but it doesn't seem to create two arrays of the same size. here is a example of tables layout: _Row_of_Data_ A B C D E F G H I J L 1 s m l m s l s _vlookup_table_ A B C D 1 s 100 2 m 1000 3 l 10000 So for Row 1 I need the following result where the values in Row 1 are used to in a vlookup to get the value from column D of the vlookup table: 100+0+1000+10000+0+1000+100+10000+0+100+0=22300 thnx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Vlookups | Excel Worksheet Functions | |||
Vlookups or Match to find multiple information | Excel Worksheet Functions | |||
multiple vlookups | Excel Worksheet Functions | |||
multiple vlookups | Excel Worksheet Functions | |||
Vlookups and multiple returns (again!) | Excel Worksheet Functions |