Svgmassive
asked on
Find matching values in excel
I would like to find matching values in two columns and add the adjacent values
Book2.xlsb
Book2.xlsb
Hi,
Not sure if I understand what you want - there appear to be no values to sum up, but see attached which may be what you want.
Alan.
EE-29055796-Book2-Version-1.xlsb
Not sure if I understand what you want - there appear to be no values to sum up, but see attached which may be what you want.
Alan.
EE-29055796-Book2-Version-1.xlsb
B2: =LOOKUP(A2,$D$1:$D$435,$E$1:$E$435)
C2: =LOOKUP(A2,$D$1:$D$435,$F$1:$F$435)
and copy down...
* in the excel you provided, all giving "#N/A" since no matching data in id column...
or you can use
B2: =IF(ISERROR(LOOKUP(A2,$D$1:$D$435,$E$1:$E$435)),"",LOOKUP(A2,$D$1:$D$435,$E$1:$E$435))
C2: =IF(ISERROR(LOOKUP(A2,$D$1:$D$435,$F$1:$F$435)),"",LOOKUP(A2,$D$1:$D$435,$F$1:$F$435))
to get rid of error and put "" when not found...
* need to sort column D-E-F I guess, which I made (may work without sort as well)...
Book2.xlsb
Couple of questions:
Are the results going to be from a single entry? ie one occurrence of ID from column A in column D
Are the anticipated values in columns E & F going to be numeric or text?
If single entry and text or number then you can use:
B2 =IFERROR(VLOOKUP($A2,$D$1: $F$107,2,F ALSE),"")
C2 =IFERROR(VLOOKUP($A2,$D$1: $F$107,3,F ALSE),"")
If multiple entry and numeric then you will need a SUMIF function:
B2 =SUMIF($D$2:$D$107,$A3,$E$ 3:$E$107)
C2 =SUMIF($D$2:$D$107,$A3,$F$ 3:$F$107)
If multiple entry and text, then this is more complicated and will need some form of VBA or User Defined Function.
Thanks
Rob H
Are the results going to be from a single entry? ie one occurrence of ID from column A in column D
Are the anticipated values in columns E & F going to be numeric or text?
If single entry and text or number then you can use:
B2 =IFERROR(VLOOKUP($A2,$D$1:
C2 =IFERROR(VLOOKUP($A2,$D$1:
If multiple entry and numeric then you will need a SUMIF function:
B2 =SUMIF($D$2:$D$107,$A3,$E$
C2 =SUMIF($D$2:$D$107,$A3,$F$
If multiple entry and text, then this is more complicated and will need some form of VBA or User Defined Function.
Thanks
Rob H
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
wow they are all good but my preference is shums.
THanks all
THanks all
wow they are all good but my preference is shums.
it would be better at least select the others as assisted...
Copy-of-Book2.xlsb
»bp