| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare and combine data with in one workbook
I have two sheets of data within one workbook. Sheet 2 provides control
numbers that I need to see on sheet 1. I would be using a column "Ticket Number" where the values in sheet 1 and sheet 2 are the same. I do I pull the contol numbers into sheet 1? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare and combine data with in one workbook
Your question is a bit vague and light on detail, but it sounds as if
VLOOKUP or an INDEX/MATCH combination will give you what you want. Post back with further detail of what you have if you need more help. Pete Kelly wrote: I have two sheets of data within one workbook. Sheet 2 provides control numbers that I need to see on sheet 1. I would be using a column "Ticket Number" where the values in sheet 1 and sheet 2 are the same. I do I pull the contol numbers into sheet 1? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I activate the xls feature to combine and compare workbooks | Setting up and Configuration of Excel | |||
| I want to combine 2 workbook data bases and remove duplicates | Excel Discussion (Misc queries) | |||
| Compare data from one column/spreasheet to another? | Excel Discussion (Misc queries) | |||
| Use charts to compare the data | Charts and Charting in Excel | |||
| Can I compare 2 lists to combine duplicate entries in new list? | Excel Worksheet Functions | |||
Linear Mode
