Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Feb 2002
    Location
    US
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Match and get related data (excel 97)

    I have two worksheets. One contains the original data.(A column is the item numbers,B column is the prices) The another is the main worksheet. In this sheet I want to show the price in column B1 when I just input the item number in A1. What is the function to compare the items and get the price from the original data into the main worksheet?
    thank you for any help

  2. #2
    Star Lounger
    Join Date
    Aug 2001
    Location
    Lebanon/France
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Match and get related data (excel 97)

    VLOOKUP is the name of this function,

    If you find excel help difficult to understand, look at the very friendly dictionary of Peter Noneley at http://homepage.ntlworld.com/noneley/files/xlfdic01.xls

  3. #3
    Lounger
    Join Date
    Feb 2002
    Location
    US
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Match and get related data (excel 97)

    Dominik
    Thank you for the info. It is very useful for my problem.
    Joe

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •