One way is via INDEX / MATCH ..
Assuming the source table below is in sheet: A, within A1:C5
Branch Name No. of participant Instructor
Nebula 5 Ellis
Pentagon 4 Winnie
Maine 6 Kenny
Corne 7 Toby
and this table is in sheet: B, within A1:C5
Instructor Name No. of participant Fee
Toby 7 840
Kenny 6 720
Ellis 5 600
Winnie 4 480
Put in B2:
=IF(A2="","",INDEX(A!B:B,MATCH(A2,A!C:C,0)))
Copy down as far as required
(For simplicity, I assumed you mean sheets rather than books)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Syahira" wrote:
Let say I have 2 wookbooks.
WB A
Branch Name No. of participant Instructor
Nebula 5 Ellis
Pentagon 4 Winnie
Maine 6 Kenny
Corne 7 Toby
WB B
Instructor Name No. of participant Fee
Toby 7 840
Kenny 6 720
Ellis 5 600
Winnie 4 480
My questions a
1) How can I link, let say the number of participant from WB A to WB B and
make sure that it is link together with instructor name.
2) If I use to just type"=" in WB B in number of participants colunm and
link it to WB A in the same column, when I sort out WB A, it get totally
wrong, how can I fix this?
Thank you for helping me.(^_^)