Hi,
I'll try and ask a different question....
E.G.
Can I return the value from A1 to cell G4, where C1 = F4...as below
A B C D
Chair Administration 7001 1
Board Administration 7002 7001
Chief Administration 7003 7001
Manager Administration 7004 7003
General Administration 7005 7001
Col G returns......
Chair
Chair
Chief
Chair
Many thanks
I'll try and ask a different question....
E.G.
Can I return the value from A1 to cell G4, where C1 = F4...as below
A B C D
Chair Administration 7001 1
Board Administration 7002 7001
Chief Administration 7003 7001
Manager Administration 7004 7003
General Administration 7005 7001
Col G returns......
Chair
Chair
Chief
Chair
Many thanks