I have a spreadsheet with one column of data, and I want to check al
the values in that column to see if they exist in another column o
data.

What types of formulas or operations exist in excel that will allow m
to accomplish this?

Michae

--
Lord M
-----------------------------------------------------------------------
Lord MJ's Profile: http://www.excelforum.com/member.php...fo&userid=2660
View this thread: http://www.excelforum.com/showthread.php?threadid=39879

Lord MJ Wrote:
> I have a spreadsheet with one column of data, and I want to check all
> the values in that column to see if they exist in another column of
> data.
>
> What types of formulas or operations exist in excel that will allow me
> to accomplish this?
>
> Michael

Hi Michael

Try this, assuming your columns of data are next to each other

=IF(ISERROR(VLOOKUP(A2,B2:B5,1)),"No match","Match")

ps are you an ex Royal Mail employee from Southampton/Portsmouth?


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=398790

You could use COUNTIF or VLOOKUP as a couple of options.

Regards

Trevor


"Lord MJ" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> I have a spreadsheet with one column of data, and I want to check all
> the values in that column to see if they exist in another column of
> data.
>
> What types of formulas or operations exist in excel that will allow me
> to accomplish this?
>
> Michael
>
>
> --
> Lord MJ
> ------------------------------------------------------------------------
> Lord MJ's Profile:
> http://www.excelforum.com/member.php...o&userid=26604
> View this thread: http://www.excelforum.com/showthread...hreadid=398790
>