Compare two sheets and combine into one

  • Thread starter Thread starter Walt Moeller
  • Start date Start date
W

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
 
Some commonly used functions that you can learn about in the XL help file to
get you started would be MATCH, VLOOKUP, or EXACT
 
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,
 
Back
Top