Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with sumproduct & dynamic ranges | Excel Worksheet Functions | |||
Need help with sumproduct and dynamic ranges | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |