[Closed - No Resolution] Lookup Formula Question

I am looking for help on a formula.

I have a two worksheet file.

On one worksheet I have every day of the year (work day) and corresponding data for many topics for that day in the column.

On the other worksheet I want the user to type in a date and have the data for that day from the first worksheet display in a specific cell (based on the date entered at the top of the sheet) on the second worksheet.

I think it is some type of lookup formula but am not sure. Any ideas?

Again: Enter todays date on one worksheet and have data display based on that date from a second worksheet. The data on the second worksheet would be manually updated every day.

Thanks and I look forward to any help.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Thanks for taking the time to read and comply with the rule .

You will want to use Vlookup()

e.g. =Vlookup(A1,'Sheet1'!A:D,2,False)

This will lookup the date in A1 and find it in Sheet1 column A, if it finds it will return the corresponding item from column B (the 2nd column in the lookup table defined by 'Sheet1'!A:D)

Have a look at that function in Excel help for more details.

Hi Tom,

Yes, it's the VLOOKUP function you're looking for. Here's an example:

Please Login or Register  to view this content.

Cheers,

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

There is also HLOOKUP which works the same as VLOOKUP except looks at the first row for matches and pulls from underneath.

e.g. =Hlookup(A1,Sheet1!A1:X100,2,False)

looks up A1 in Sheet1!A1:X1 and pulls from row 2 (i.e. A2:X2)

If you post a sample workbook showing what you need to get done, perhaps there is a way.. there are alternatives to Vlookup() and Hlookup()...