| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with match function
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 & 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 & F2? +-------------------------------------------------------------------+ |Filename: test1.zip | |Download: http://www.excelforum.com/attachment.php?postid=4653 | +-------------------------------------------------------------------+ -- nander ------------------------------------------------------------------------ nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156 View this thread: http://www.excelforum.com/showthread...hreadid=533891 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| Complicated Index Match Offset function | Excel Worksheet Functions | |||
| Lookup function problem (kg) | Excel Worksheet Functions | |||
| Excel Function to Match Power Trendline in Chart? | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
Threaded Mode
