=INDEX(Name,MATCH(INDIRECT(E8)&INDIRECT(D8),INDIRECT(Job)&INDIRECT(time_in),1))

[Nazerith]

=INDEX(Name,MATCH(INDIRECT(E8)&INDIRECT(D8),INDIRECT(Job)&INDIRECT(time_in),1))

Format of cells is
Name, Job, Time in

I put this in an array and i get REF error

Cell D8 is just the name of the job as a fixed value in the worksheet


cell E8 time in cell has this formula in it to get its value
=INDEX(Sheet20!$C$3:$C$19,SMALL(IF(Sheet20!$A$3:$A$19=D8,ROW(Sheet20!$A$3:$A$19)-ROW(Sheet20!$A$3)+1),2))

 

[Saagar]

What are the current values in cells E8 and D8?

 

[Nazerith]

E8= 4:00PM using the formula above to look it up.


D8= Utility

 

[Saagar]

I suspect your usage of INDIRECT function is incorrect. Please refer to Excel Help and verify if your understanding of the INDIRECT function is correct.

Also second parameter of the MATCH function needs to be an array.

Instead of asking us to fix your formula, we might be able to help you better if you give a sample of your data and explain what you are trying to achieve.

Good luck!