[Walt Moeller]

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

[Luke M]

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

[xlm]

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