Put this in B1 of Sheet1:

=IF(ISNA(MATCH(A1,Sheet2!A:A,0)),"not in list 2","present in list 2")

then copy the formula down by double-clicking the fill handle (the
small black square in the bottom right corner of the cursor) with B1
selected. It will tell you if the number is present in the second list
or not.

Hope this helps.

Pete

On Jun 23, 11:09*pm, Mary C (donotspam)
wrote:
Sorry,
First Spreadsheet Column A
5050142552
8704046547
9902863308
5052020251
2599090534
8702794441
5000401686
8702007687

Second Spreadsheet1 Column A
5050142552
9902863308
5052020251
8702794441
5000401686
8702448016
5052084935

I need to create a column on Spreadsheet 1 to match the numbers from
speadsheet 1 and spreadsheet 2.

--
Mary C



"Pete_UK" wrote:
Give some details about how those sheets are laid out and what data
you have in them, together with a clearer explanation of what you are
trying to do.

Pete

On Jun 23, 10:46 pm, Mary C (donotspam)
wrote:
I have 2 differant spreadsheets and need to find matching data on them. *What
would I use to do it and how?
TIA
--
Mary C- Hide quoted text -

- Show quoted text -