Raffle

[leoj823]

i'm putting together a raffle for a charity. I have 20 sheets with numbers from 10001 to 12000. each sheet has 100 numbers on them. I have a master sheet at the beginning. On the 20 sheets each selected number has a name address and zip code. on the mastersheet I want to enter the winning number on the master sheet and have it automatically fill in the name address and zipcode on the master sheet from the other sheets Is that doable?

 

[FDibbins]

what are your sheet names?
If you give then the name of the 1st number in that "set", you could probably use INDIRECT with vlookup() to return the data you want?

 

[Michael M]

HAve a look at this other thread, for lookups across multiple sheets

http://www.mrexcel.com/forum/excel-questions/741879-vlookup-across-multiple-worksheets.html