Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

# looking up a value from list

### #1 vally Posted 23 November 2008 - 03:31 AM

vally

Member

• Member
• 590 posts
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.

• 0

### #2 Vino Rosso Posted 23 November 2008 - 06:16 AM

Vino Rosso

Visiting Staff

• Visiting Consultant
• 235 posts
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!"
• 0

### #3 vally Posted 23 November 2008 - 10:59 AM

vally

Member

• Topic Starter
• Member
• 590 posts
I tried it but I messed some thing up.
I will play around with it tomorrow.
and get back 2 u
• 0

### #4 vally Posted 24 November 2008 - 02:31 AM

vally

Member

• Topic Starter
• Member
• 590 posts
Thanx Vino Rosso
I played around and set it up so it works the way I need.
• 0

### #5 Vino Rosso Posted 24 November 2008 - 02:49 AM

Vino Rosso

Visiting Staff

• Visiting Consultant
• 235 posts
You're welcome
• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users