Working with multiple worksheets - Match info from Master and carry over to worksheet

[JonBindley]

Please bear with me - this is my first day on this forum - I'll do my best to explain what is it I am trying to acccomplish. I have a excel spreadsheet with 2,500 rows (named Master) then I have 12 tabs within this worksheet (Jan-Dec). The master worksheet contains the following columns: A1 = Calendar # B1 = Name C1 = Financial Institution

Each month a drawing of random numbers are drawn - I would like to be able to click on the appropriate tab, insert the Winning Calendar # and have excel automatically look at the Master Sheet and bring over the Name and Financial Institution.

I really appreciate any help I can get. I've also attached a copy of the Excel File. Thank you so much.

[Jockney]

Use this code in C6 of the calendar tab

Please Login or Register  to view this content.

this looks up the value in B6 within A2:A6 of the master calendar. Then it goes across 1 column and picks out the value which sits next to it. If you need any more help then please let me know.

[boopathiraja]

HI,
Refer the attachment

[JonBindley]

Perfect - thank you so much