Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

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

1. I agreed to these rules
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. Super M‌oderator
Join Date
4th July 2004
Location
Posts
2,371

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

On Sheet 2...

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

Hope this helps!

Excel Video Tutorials / Excel Dashboards Reports

3. I agreed to these rules
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

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

#### 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