J
John
Can anyone explain why a #Ref! is returned with the following formula
=IF(INDEX(Address1,MATCH(D9,EmployeeNames,0))=0,"No Address in
Timepoint",INDEX(Address1,MATCH(D9,EmployeeNames,0)))
I have identified it to a Row where it starts (and continues below in every
other row), but there doesn't seem to be anything wrong with this particular
row, i.e. there is address data in the particular cell
Thanks
=IF(INDEX(Address1,MATCH(D9,EmployeeNames,0))=0,"No Address in
Timepoint",INDEX(Address1,MATCH(D9,EmployeeNames,0)))
I have identified it to a Row where it starts (and continues below in every
other row), but there doesn't seem to be anything wrong with this particular
row, i.e. there is address data in the particular cell
Thanks