Value Error!!!

[KristiGohs81]

Hi There!

This may be a simple fix, however, I just can't seem to figure it out! I have two workbooks that I currently work from for payroll. The following is a formula used to reference an 'Employee ID' to pull their 'Rate' from a master work book. I have checked all of the columns it is referencing to confirm that the data within those columns is correct and in the correct format. I am still getting a Value error in the cell. When I evaluate the formula it is also giving the FALSE right from the start. Can anyone help me out with this??

=IF([@[Pay Code]]="OT",INDEX('Master(Admin).xlsm'!GPHRates[Rate],MATCH([@EmpID]&[@Pos],'Master(Admin).xlsm'!GPHRates[EmpID]&'Master(Admin).xlsm'!GPHRates[Code],0))*1.5,INDEX('Master(Admin).xlsm'!GPHRates[Rate],MATCH([@EmpID]&[@Pos],'Master(Admin).xlsm'!GPHRates[EmpID]&'Master(Admin).xlsm'!GPHRates[Code],0)))

 

[RoryA]

Did you array-enter the formula?

 

[KristiGohs81]

Did you array-enter the formula?

Hi RoryA!

Yes I did.

Thanks!

 

[KristiGohs81]

Hi RoryA!

Yes I did.

Thanks!

This was correct! Actually, I guess I did not. That was the easiest fix ever, not sure why I missed it. BUT YOU ARE A LIFE AND SANITY SAVER!!!!!! Having to manually check hundreds of employees rates was time consuming and monotonous!!

You have no idea how much this has helped me!!!!!! I actually have a new question though, that perhaps you can help me with as well!