compare and combine data with in one workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match and delete rows on two different sheets from reference numbers 4
Combine data - Please help 1
COUNT rows on external sheet if between date range 3
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Matching Data 1
SUMIF or SUMIFS help 1
Create 3rd data set off comparison of 2 other sets 2
Collapsing all groups 0

Back
Top