Jump to content

Welcome to Geeks to Go - Register now for FREE

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
Photo

looking up a value from list


  • Please log in to reply

#1
vally

vally

    Member

  • Member
  • PipPipPip
  • 573 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

Advertisements


#2
Vino Rosso

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

vally

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 573 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

vally

    Member

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

#5
Vino Rosso

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

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP