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

# Excel finding a value in a table

### #1 vally Posted 11 December 2008 - 08:41 AM

vally

Member

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

### #2 Vino Rosso Posted 11 December 2008 - 04:34 PM

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 Posted 14 December 2008 - 02:53 AM

vally

Member

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