software

In this spreadsheet test1 I have 5 worksheets. I want in the Master
worksheet to be the destination worksheet for the data in the other
worksheets. the data for the 3 columns MULT Contract Price.Point comes
from Type, Sales 01, Sales 02 amp; Pointer.

so in the master worksheet, the value of cell D1 should be from the CL
in cell C2 compared to the CUST CLASS column in worksheet TYPE. AND
worksheet SALES01 . I would like the CONTRACT AND PRICE POINT values in
the MASTER worksheet to come from SALES01. what do I need to do to
correct the formula that is in cell D2 and what do i need in cell E2 amp;
F2? -------------------------------------------------------------------
|Filename: test1.zip |
|Download: www.excelforum.com/attachment.php?postid=4653 |
-------------------------------------------------------------------

--
nander
------------------------------------------------------------------------
nander's Profile: www.excelforum.com/member.php...foamp;userid=6156
View this thread: www.excelforum.com/showthread...hreadid=533891
Your sub formula MATCH(C2,{0,500,2500,7500},1) appears to be trying to
look up a text value in an array of numbers and giving the error.--
mrice------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=533891
Okay then can you suggest a corrected formula. I was given this formula
and I really don't understand how it works.--
nander
------------------------------------------------------------------------
nander's Profile: www.excelforum.com/member.php...foamp;userid=6156
View this thread: www.excelforum.com/showthread...hreadid=533891You probably have a better chance of getting an answer if you post a sample
of the data (as text in the body of your message) since many of the regulars
don't open workbooks from strangers due to virus risk.

--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;nanderquot; gt; wrote in
message ...
gt;
gt; Okay then can you suggest a corrected formula. I was given this formula
gt; and I really don't understand how it works.
gt;
gt;
gt; --
gt; nander
gt; ------------------------------------------------------------------------
gt; nander's Profile:
gt; www.excelforum.com/member.php...foamp;userid=6156
gt; View this thread: www.excelforum.com/showthread...hreadid=533891
gt;

I can cut and past parts of the spreadsheet but it will appear
unstructured.

CUSTVOLUME
CLASSgt; 7,5007,499-2,5002,499 - 500lt; 500
25NEW CUSTOMER0.500.500.550.60
0ZRETAIL0.700.700.700.70
AGAGRICULTURE amp; FARMING0.600.600.600.60
APAPARTMENTS0.500.500.550.60
ASAPPLIANCE SERVICE0.500.500.500.55
ATATTRACTIONS0.550.550.550.55
BRJOHNSTONE BRANCH SALES0.450.450.450.45
CHCHURCHES0.600.600.600.60
ELELECTRICAL0.500.500.550.60
EMEMPLOYEE0.500.500.500.50
FXO/E FAX# ADDED CUST.MAST0.500.500.550.60
GAGAS COMPANY0.500.500.550.60
GCGENERAL CONTRACTORS0.500.550.550.60
GRGROCERY STORES0.550.550.550.55
GVCITY, COUNTY, STATE amp; FED0.550.550.550.60
HAHTG AC amp; APPL0.450.470.500.55
HLHOSPITALS amp; NURSING HOMES0.500.500.550.60
HOHOTELS, MOTELS amp; INNS0.500.500.550.60

CUST#CUST.NAMETYPCLMULTContractPRICE.POINTCITYSTATEZIP.CODECO#
100162FAULTON DOUGLASHVHV#N/A#N/AABBEVILLEAL3631001
102038CURTIS APPLIANCE REPAIR amp;ASASABBEVILLEAL3631001
103715GREAT SOUTHERN WOOD PRESEININABBEVILLEAL3631001
104306HENRY CO NURSING HOMEHLHLABBEVILLEAL3631001
104312HENRY CO BOESCSCABBEVILLEAL36310-063501
104313HENRY CO BRD OF EDUCATIONSCSCABBEVILLEAL3631001
104369AW HERNDON OIL CO INCMCMCABBEVILLEAL3631001
104390HERNDON OIL CORPORATIONMCMCABBEVILLEAL36310-065501
105340Jamp;J REPAIR amp; A/C SERVICE01HVABBEVILLEAL3631001
108086TELEDYNE ABBEVILEININABBEVILLEAL3631001
122027ANDALUSIA HSNG AUTHORITYGVGVANDALULSIAAL36420-479101
122030ANDALUSIA MANORHLHLANDALULSIAAL36420-000001
100175ALABAMA ELECTRIC CO-OPGVGVANDALUSIAAL36420-055001
101891COVINGTON CO SCHOOLSSCSCANDALUSIAAL36420-046001
102630DRAPER HEATING A/C amp; REFHRHRANDALUSIAAL3642001
102882BUTLER AIR CONDITIONING01HVANDALUSIAAL3642001
105400KILPATRICK SHEET METALHRHRANDALUSIAAL3642001
105650LLOYD'S REFRIGERATION03HRANDALUSIAAL3642001
CUST#CUST.NAMETYPCLSALES 12MOMULTContract..CO#ABC
108065TED'S HEATING amp; COOLING0.00109,936.380.45HVAC1A
100211ANDERSON'S REPAIR SERVIC0.00108,907.020.45SHVAC1A
105104JIMMY'S Hamp;C - DOTHAN0.00100,949.720.45LHVAC1A
106140NORTH AIR0.0069,851.830.45HVAC1A
1111CASH - DEALER/CONTACTOR0.0067,479.190.451A
107530SNELLGROVE amp; CAYLOR Hamp;C0.0064,145.940.45LHVAC1A
100069KELLY'S HEATING amp; COOLIN0.0061,687.400.45HVAC1A
109540MERRITT'S (JERRY) Hamp;C0.0053,227.930.45HVAC1A
103088FAILS HEATING amp; A/C0.0052,454.890.45HVAC1A
110375BLUDSWORTH SERVICE COMPA0.0043,614.190.451A
104789HOUSTON CO BOE0.0041,901.520.451A
101175COMFORT SYSTEMS U.S.A.0.0039,202.610.45LHVAC1A
104579HOLLIS REFRG amp; APPL SVC0.0038,781.960.45SHVAC1A
109178WOODALL Hamp;C INC.0.0037,716.740.45LHVAC1A
109997MOBLEY REF amp; ELEC SVC IN0.0036,539.330.45SHVAC1A
106889RELIABLE SERVICE CO0.0035,988.360.45REF1A
CUST#CUSTOMER NAMECITY.STATE.ZIPPRICE.POINTABCCO#
1111CASH - DEALER/CONTACTORDOTHAN, AL 363010A1
10051JOHNSTONE #51KNOXVILLE, TN 37950-1D1
100018JOHNSTONE OF MEMPHISMEMPHIS, TN 38112-1D1
100019JOHNSTONE OF SAVANNAHSAVANNAH, GA 31401-1D1
100020JOHNSTONE OF MOBILEMOBILE, AL 36609-1D1
100021JOHNSTONE OF NEW ORLEANSHARAHAN, LA 70183-0716-1D1
100022JOHNSTONE OF PENSACOLAPENSACOLA, FL 32505-1D1
100023JOHNSTONE OF TALLAHASSEETALLAHASSEE, FL 32304-1D1
100024JOHNSTONE OF NASHVILLENASHVILLE, TN 37210-1D1
100026JOHNSTONE OF BIMINGHAMBIRMINGHAM, AL 35222-1D1
100027JOHNSTONE OF GAINSVILLEGAINESVILLE, FL 32609-1D1
100029JOHNSTONE NAPERVILLENAPERVILLE, IL 60563-1D1
100033JOHNSTONE SUPPLY #37ST.PETERSBURG, FL 33714-1D1
100035JOHNSTONE OF HUNTSVILLEHUNTSVILLE, AL 35816-1D1
100036JOHNSTONE OF JACKSONVILLJACKSONVILLE, FL 32204-1D1
100039WASHINGTON CO KENNEL CLUEBRO, FL 324370D1
100050JOHNSTONE SUPPLY CLARKVLCLARKSVILLE, TN 37040-1D1
100063JOHNSTONE SUPPLY W PALMWEST PALM BEACH, FL 33309-1D1
100064JOHNSTONE BATON ROUGE #1BATON ROUGE, LA 70816-1D1
100068SWEE****ER APARTMENTSDOTHAN, AL 363050C1
100089SOUTHERN PIPE amp; SUPPLYFLORENCE, AL 356300D1
100107JOHNSTONE GULFPORT 220GULFPORT, MS 39501-1D1
100108JOHNSTONE MDCMEMPHIS, TN 38118-7432-1D1
100111BAY ST JOSEPH CAREPORT ST. JOE, FL 324560C1--
nander
------------------------------------------------------------------------
nander's Profile: www.excelforum.com/member.php...foamp;userid=6156
View this thread: www.excelforum.com/showthread...hreadid=533891