Compare two sheets and combine into one
 

I have two spread sheets and I would like to use a common column between the
two to create a combination / compare new sheet. This sheet would use the
common column as the reference column but also compare the information in 2
other common columns

Thanks
--
Walt Moeller

Compare two sheets and combine into one
 

Some commonly used functions that you can learn about in the XL help file to
get you started would be MATCH, VLOOKUP, or EXACT
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Walt Moeller" wrote:

I have two spread sheets and I would like to use a common column between the
two to create a combination / compare new sheet. This sheet would use the
common column as the reference column but also compare the information in 2
other common columns

Thanks
--
Walt Moeller

Compare two sheets and combine into one
 

Like Luke have mentioned, there's a couple of functions that you can use from
the Help file.

I suggest that you post a sample of your data in 2 sheets and what is the
result
you are looking for so that we can of assistance.


--
If this posting was helpful, please click on the Yes button

Thank You

cheers,









"Walt Moeller" wrote:

I have two spread sheets and I would like to use a common column between the
two to create a combination / compare new sheet. This sheet would use the
common column as the reference column but also compare the information in 2
other common columns

Thanks
--
Walt Moeller