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

how do I decide what function to use


  • Please log in to reply

#1
smpkge

smpkge

    New Member

  • Member
  • Pip
  • 7 posts
Here is my problem... I know there is a way to do what I am trying to do, but I am having a brain block.

I have 1 worksheet page that is an export. The export contains numbers, names, address and specific contacts. On the 2nd worksheet is where I need the function.

If a row in my export contains a specific name, I want that entire row from the export sheet to copy over to the 2nd worksheet. So it would look something like this.

Export Page
A B C D E F
1 Joe Smith 1234 Happy Lane Happyville USA Rachel
2 Andy Brown 2940 Smile Drive Smileville USA Rachel
3 Jane Doe 3920 Deer Court Deerfield USA John
4 Mary Johnson 324 32nd Street Anywhere USA John

2nd Page
If any of these rows contain the name Rachel, then I would like for the corresponding columns A-E to fill in on the second sheet.


I hope I made my question clear enough... I hope someone can help me fast!!!!
Thanks,
Smpkge
  • 0

Advertisements


#2
dsm

dsm

    Member

  • Member
  • PipPip
  • 98 posts
Try the function "vlookup"


HTH
David
  • 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