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