Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Pulling information from two worksheets

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How do I write this formula? I need to put the information from a table, comprised of two columns (B & C), found on Sheet 2, into one column (A) found on Sheet 1. It could be done as an If statement: If on Sheet 2, column B are varieties of candy and Sheet 2, column C has the price of each, Then the price for the item on Sheet 1, A1 would be ___. How do I write that?

    [ This Message was edited by: Alexander on 2002-04-19 12:35 ]

    [ This Message was edited by: Alexander on 2002-04-19 12:36 ]

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-19 12:34, Alexander wrote:
    How do I write this formula? I need to put the information from a table, comprised of two columns (B & C), found on Sheet 2, into one column (A) found on Sheet 1. It could be done as an If statement: If on Sheet 2, column B are varieties of candy and Sheet 2, column C has the price of each, Then the price for the item on Sheet 1, A1 would be ___. How do I write that?
    =VLOOKUP(A1,Sheet2!$B$2:$C$100,2,0)

    Adjust the range in Sheet2 to suit.

    Aladin

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, Aladin. Works great!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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