What function do I use?

  • Thread starter Thread starter Jambruins
  • Start date Start date
J

Jambruins

In worksheet 1 I have a date in cell A1. Worksheet 2 has a date i
column A with a team name in column B and C.

For example, sheet 2 looks like this (Cell A1 Cell B1 Cell B2).
13-Oct-04 Candiens Senators

I want cell B2 in worksheet 1 to equal the team in cell A2 (workshee
2) for the corresponding date in cell A1 (worksheet 1).

How would I do this? Thank you
 
if my wording is confusing please let me know and I will try to explai
it a different wa
 
Can you confirm that you have your references stated correctly i.e. do you
mean A1, B1 and B2 on worksheet 2?

Rob
 
Frank, I have it set up so it works great for 13-Oct-04 but when
change the date to 14-Oct-04 it only takes the first row.

For example, there are 7 instances on worksheet 2 with the dat
13-Oct-04. It grabs cell B1 and C1 from sheet 2 and puts them i
cells B2 and B3 in sheet 1. Then it grabs cell B2 and C2 and puts the
in B5 and B6 in sheet 1. It does this for all 7 instances. However
when I change the date to 14-Oct-04 and delete all the data fo
13-Oct-04 in sheet 2 it grabs cells B1 and C1 from sheet 2 and put
them in B2 and B3 but also in B5 and B6. I need it to grab cells B
and C2 and put this data in B5 and B6. I hope you can follow this.

Rob, sorry that should have been A1, B1, and C1
 

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

countifs Function not giving desired result with date criteria 2
Comparison of columns using Conditional Formatting 3
vlookup help 9
How can I add the values based the color of font and the date 1
Date to Day 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel 2003 - Copy Down Function to Reference Next Worksheet 3
separating date and time 5

Back
Top