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

Excel finding a value in a table


  • Please log in to reply

#1
vally

vally

    Member

  • Member
  • PipPipPip
  • 573 posts
I have an excel document.
In one column I have a number and I want to find if is in a different column and to return the data in the adjacent l over.
Thanx for any help
  • 0

Advertisements


#2
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
=vlookup([cell in column with number],[table range],2,FALSE)

So, let's say the numbers you want to look for are in column A, the number you want to find are in column Y - therefore the data you want to return is in column Z. Let's say you want to write this data to column B. In all cases, the data runs to row 100.


Formula in B2 would be =vlookup(A2,$Y$2:$Z$100,2,FALSE)

Drag this formula down the cells in column B.
  • 0

#3
vally

vally

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 573 posts
Thanx :)
I managed to play around with it and get what I needed to use. :)
  • 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