ExcelBanter - compare and combine data with in one workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - compare and combine data with in one workbook (https://www.excelbanter.com/excel-worksheet-functions/113552-compare-combine-data-one-workbook.html)

Kelly

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?

Pete_UK

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?

All times are GMT +1. The time now is 10:02 PM.