Extract specific data from table to other based on id number

hi best excel forum,

can you please help me to extract specific data from table to other based on id number.

Please see excel sheet .

NOTE:

THIS IS JUST AN EXAMPLE ALL NUMBER AND NAME NOT REAL JUST FOR TESTING.


Thank you very much

banda

Originally Posted by eastw00d

you can use this function to achieve this:

Please Login or Register  to view this content.

cheers
erwin

thank you very much, my problem solved