[vally]

Hi
I have table in excel with a column of serial numbers.
I have on another document a many of the same serial numbers.
want to make a marking or column next to the serial that will tell me that the number exist.
Any help will b appreciated.
vally

P.s. I have office 2003

Edited by vally, 23 November 2008 - 03:31 AM.

[Advertisements]

Hi

Office 2007 has IFERROR which would be easier to use.

As ever with Excel, there are various ways to do things. One way that should get what you want is:

=IF(ISNA(VLOOKUP([Cell with Serial Number],[Range of serials numbers to check],1,FALSE)),"Not there!", (VLOOKUP([Cell with Serial Number],[Range of serials numbers to check],1,FALSE)))

so if the first range of serial numbers runs from cell A1 and the second range is on sheet 2 from A1, the formula in B1 of the first sheet would be:

=IF(ISNA(VLOOKUP(A1,Sheet2!$A:$A,1,FALSE)),"Not there!", (VLOOKUP(A1,Sheet2!$A:$A,1,FALSE)))

Replicate the formula down column B.

The result is that where the serial number exists, it is shown in column B (as a check). If it doesn't exist, you'll see "Not there!"

[Vino Rosso]

Hi

Office 2007 has IFERROR which would be easier to use.

As ever with Excel, there are various ways to do things. One way that should get what you want is:

=IF(ISNA(VLOOKUP([Cell with Serial Number],[Range of serials numbers to check],1,FALSE)),"Not there!", (VLOOKUP([Cell with Serial Number],[Range of serials numbers to check],1,FALSE)))

so if the first range of serial numbers runs from cell A1 and the second range is on sheet 2 from A1, the formula in B1 of the first sheet would be:

=IF(ISNA(VLOOKUP(A1,Sheet2!$A:$A,1,FALSE)),"Not there!", (VLOOKUP(A1,Sheet2!$A:$A,1,FALSE)))

Replicate the formula down column B.

The result is that where the serial number exists, it is shown in column B (as a check). If it doesn't exist, you'll see "Not there!"

[vally]

I tried it but I messed some thing up.
I will play around with it tomorrow.
and get back 2 u

[vally]

Thanx Vino Rosso
I played around and set it up so it works the way I need.

[Vino Rosso]

You're welcome