If, then formula to capture data?

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

Guest

Hope I'm in the right forum...

What I'd ultimately try to do is to have a link between sheets but with
different data being propagated. Such as:

Sheet "A" is the schedule sheet with employee names listed. Let's say
Employee "1" is listed in cell A1 and I input 9:30 AM in cell B1 (i.e.,
Employee "1" scheduled for 9:30).

Sheet "B" is a list of the schedule times. If 9:30AM is in cell A4, is there
a way to automatically propagate "Employee 1" into B4 when "9:30 AM" is input
to B1 on Sheet "A"?

I suppose the formula I'm looking for is something like:
=if(sheet1!B1="Employee 1")="Employee 1"

Thanks (I think I'm moving into "Access" here)
 
Try this: enter in B1 on Sheet2 and copy down. It assumes a 1:1 relationship
between an employee and a time. If multiple employees can have the same time,
then it will not work.

=IF(ISNA(MATCH(A1,Sheet1!B:B,0)),"",INDEX(Sheet1!$A$1:$A$1000,MATCH(A1,Sheet1!B:B,0)))

HTH
 
Thanks, the formula worked fine when I pasted it into a test sheet, but when
I tried it in my project and changed the cell references to match up, I
started to get errors. Any idea where I might be going wrong?

Thanks again
 

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

Back
Top