IF and INDEX formula

[bemp87]

Hi Community, I'm needing some help with a IF and INDEX formula, and here is what I have so far:

1) I have a data validation List ranging from A1:A25 (working sheet)
2) I have a data sheet that includes a list of names with their work schedules
a) on the data sheet cell A1 will be a name, B1 will be a start time, and C1 will be a end time
3) I am trying to create a IF formula on my working sheet that will basically look for a specific value in cell A1 and return the corresponding value into cell B1... i am using this formula =IF(A1=Datasheet!A2:A25,INDEX((Datasheet!!B2:Z25),1,0,1))
4) Essentially what i would like to happen is that IF any value in cell A1 on my working sheet = a corresponding value from the data sheet that it will return in cell B1 and C1 the start and end time of that corresponding person.

After using the formula I am getting a FALSE message, am i doing something wrong. I know this can be doing by writing a separate IF statement for every name, but was hoping there was a better or easier way to do this.

Any help would be much appreciated...

 

[wideboydixon]

B1 formula:

=IFERROR(INDEX(Datasheet!B$2:B$25,MATCH($A1,Datasheet!$A$2:$A$25,0)),"?")

You should then be able to copy the formula to C1.

WBD

 

[bemp87]

Hi WBD - Thanks for the help, when putting the code you provided in cell B1 all that returns is a ?....Not sure what i am missing or did wrong in putting in the formula, any guidance?

 

[wideboydixon]

That means that it didn't find a match for the value in A1 - is that definitely in the list?

WBD

 

[bemp87]

It was my mistake, it is working as intended, I had an error on my part but it has been corrected and the formula works perfectly. Thanks so much for the help this makes my life a million times easier!!!!