Compare two sheets and combine into one

[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

 

[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

 

[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,