1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: common problem needing a little direction

Discussion in 'Business Applications' started by Lex.Luthor, Oct 29, 2011.

Thread Status:
Not open for further replies.
  1. Lex.Luthor

    Lex.Luthor Thread Starter

    Joined:
    Jun 28, 2008
    Messages:
    263
    I hope that this has been answered several times before. I am using MS 2007 excel. Attached is a sample. Here is what I want to do:

    In the second sheet I want to be able to search all of the data of sheet 1 in the part column, find the matching information and entering the cost into the second sheet . Rather than using a copy/paste all of the time. I hope that I am able to explain this.

    Any and all help on this will be really appreciated.

    Thank you very much.
     

    Attached Files:

  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Hi Lex,
    You could use VLOOKUP but then this only works, as far as I know with text not numbers.
    I reatttached your sheet with the VLOOKUP necxt to your column and you see two values retrund because \i changed one to a text string to test.
     

    Attached Files:

  3. Lex.Luthor

    Lex.Luthor Thread Starter

    Joined:
    Jun 28, 2008
    Messages:
    263
    Keebellah,

    I've looked at the results from what you have tested out and I was thinking that I could use the vlookup function, but I have not that much experiece with vlookup. I was thinking that it coulbe be the vlookup or maybe the "IF" function. This one looks like that you have gotten this one dead on.

    I'm giving you a "gold star" on this one :)

    Thank you very much.

    Marked this one solved!
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1024502

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice