Hi Gary,

To help you I think someone would have to look at your workbook and the
sheets, then you would have to explain exeactly what you want pulled from the
sheet or sheets. Your question is too general in nature, if that makes sense.

Thanks,
David

"gbeard" wrote:

I have 6 different sheets in my workbook 1 for each of my 5 different
districts in my company and one main sheet. Is it possible to put the
district number in a cell on the main sheet and then reference that cell in
an IF statement to pull data from a particular district? By changing the
value in that single cell, I'd be able to find the same data from each of my
districts.
BTW, I can't use a VLOOKUP or HLOOKUP since the data I am trying to pull is
not in numerical order.

Any help or ideas would be appreciated,
Gary