How to extract the same data from different sheets

P

program_info

Hi,
I need to extract the common and same data from four different sheets
into one sheet. Could you please let me know how to do it?

I can use VLOOKUP, but I need to generate one temperary sheet for any
two sheets. And based on these temperary sheets, I need to use VLOOKUP
to generate other temperary sheets. And then finally I could get the
last result. Too complex.


THanks.
--Kening
 
J

Jerry W. Lewis

Can you say more about the structure of your data, how you are
identifying "common and same data" and why you need all those temporary
sheets to use VLOOKUP?

Jerry
 
P

program_info

Thank you. Jerry and Peter.
I've got the answer.
I use IF and MATCH functions to do it. It is not very complex.

I appreciate that you answered my email.


--Kening
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top