Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Pull value from one sheet based on input in another sheet

  1. #1
    Join Date
    11th November 2004
    Posts
    2

    Pull value from one sheet based on input in another sheet

    I am trying to pull\display the value from worksheet 1 based on a value entered in worksheet 2. In worksheet 1, column A has values ranging from 18 to 64 with column B having a different value for each (ex. a1=18, b1=188; a2=19, b2=194; a3=20, b3=197, etc.) In worksheet 2, I have one cell where I enter a value from 18 to 64. How do I get the Column B value of worksheet 1 that corresponds to the number I entered on worksheet 2 to appear in a cell on worksheet 2?

    Example: I enter '20' in a cell on worksheet 2. I want to display on worksheet 2 the value from worksheet 1 column B that corresponds with 20 in worksheet 1 column A (in the ex. above the value would be 197).

    Any help is GREATLY appreciated! I tried the if statements but am limited to just 7 if's- so it was not feasible since there are 47 possible values. Thank you in adavnce for any assistance.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    4th July 2004
    Location
    Canada
    Posts
    2,292

    Re: Pull value from one sheet based on input in another sheet

    On Sheet 2...

    =VLOOKUP(A1,Sheet1!A1:B3,2,0)

    ...where A1 contains your lookup value and Sheet1!A1:B3 contains your lookup table. Adjust the range for your lookup table accordingly.

    Hope this helps!

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    11th November 2004
    Posts
    2

    Re: Pull value from one sheet based on input in another sheet

    Thanks a bunch- I'll give it a try.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 10
    Last Post: April 15th, 2009, 08:19
  2. Replies: 4
    Last Post: April 4th, 2007, 03:00
  3. Replies: 15
    Last Post: October 18th, 2006, 10:06
  4. Replies: 1
    Last Post: June 21st, 2006, 00:01

Bookmarks

Posting Permissions

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