SUMPRODUCT
 

Need to populate worksheet a col B based on the following:
if worksheet a col a = worksheet b col a, then populate worksheet a col b
from worksheet b col b.

worksheet a worksheet b
COL A COL B COL A COLB
ahj dgh sclmbnk
dgh eff sclmtfs
sre fgh sclmbnk
fgh sre sclmhrm

Thanks in advance.

SUMPRODUCT
 

Im guessing you dont want the entire column A to match between sheets?

If you DO, in cell B1 of worksheet a:

=if((worksheeta!a:a)=(worksheetb!a:a),worksheetb!b 1,"")

and drag down.

If its just on a per-cell basis:

=if(worksheeta!a1=worksheetb!a1,worksheetb!b1,"")

and drag down.

-Sean

scire wrote:
Need to populate worksheet a col B based on the following:
if worksheet a col a = worksheet b col a, then populate worksheet a col b
from worksheet b col b.

worksheet a worksheet b
COL A COL B COL A COLB
ahj dgh sclmbnk
dgh eff sclmtfs
sre fgh sclmbnk
fgh sre sclmhrm

Thanks in advance.

SUMPRODUCT
 

Both formauls did not work.
Sorry, I did not make it very clear.
Worksheet a Col a, should exist in worksheet b col a and populate
corespnding col b to worksheet a bol b ie

if worksheet a col a in found anywhere in worksheet col b, then take the
contents of worksheet b col b and copy to worksheet a col b.
COL A COL B COL A COLB
ahj dgh sclmbnk
dgh eff sclmtfs
sre fgh sclmbnk
fgh sre sclmhrm

The results shouls be as follows:
COL A COL B COL A COLB
ahj dgh sclmbnk
dgh sclmbnk eff sclmtfs
sre sclmhrm fgh sclmbnk
fgh sclmbnk sre sclmhrm

have the following formula and if doesnot work:
=IF((worksheeta!B3)=(Workareab!B4:B2205),C3,"")

Thanks,
Scire


"S Davis" wrote:

Im guessing you dont want the entire column A to match between sheets?

If you DO, in cell B1 of worksheet a:

=if((worksheeta!a:a)=(worksheetb!a:a),worksheetb!b 1,"")

and drag down.

If its just on a per-cell basis:

=if(worksheeta!a1=worksheetb!a1,worksheetb!b1,"")

and drag down.

-Sean

scire wrote:
Need to populate worksheet a col B based on the following:
if worksheet a col a = worksheet b col a, then populate worksheet a col b
from worksheet b col b.

worksheet a worksheet b
COL A COL B COL A COLB
ahj dgh sclmbnk
dgh eff sclmtfs
sre fgh sclmbnk
fgh sre sclmhrm

Thanks in advance.

SUMPRODUCT
 

sounds like you are looking for VLOOKUP

http://www.contextures.com/xlFunctions02.html

"scire" wrote:

Both formauls did not work.
Sorry, I did not make it very clear.
Worksheet a Col a, should exist in worksheet b col a and populate
corespnding col b to worksheet a bol b ie

if worksheet a col a in found anywhere in worksheet col b, then take the
contents of worksheet b col b and copy to worksheet a col b.
COL A COL B COL A COLB
ahj dgh sclmbnk
dgh eff sclmtfs
sre fgh sclmbnk
fgh sre sclmhrm

The results shouls be as follows:
COL A COL B COL A COLB
ahj dgh sclmbnk
dgh sclmbnk eff sclmtfs
sre sclmhrm fgh sclmbnk
fgh sclmbnk sre sclmhrm

have the following formula and if doesnot work:
=IF((worksheeta!B3)=(Workareab!B4:B2205),C3,"")

Thanks,
Scire


"S Davis" wrote:

Im guessing you dont want the entire column A to match between sheets?

If you DO, in cell B1 of worksheet a:

=if((worksheeta!a:a)=(worksheetb!a:a),worksheetb!b 1,"")

and drag down.

If its just on a per-cell basis:

=if(worksheeta!a1=worksheetb!a1,worksheetb!b1,"")

and drag down.

-Sean

scire wrote:
Need to populate worksheet a col B based on the following:
if worksheet a col a = worksheet b col a, then populate worksheet a col b
from worksheet b col b.

worksheet a worksheet b
COL A COL B COL A COLB
ahj dgh sclmbnk
dgh eff sclmtfs
sre fgh sclmbnk
fgh sre sclmhrm

Thanks in advance.