Locate ID on multiple worksheets

[tmitchell52]

I have a document that has an ID on multiple worksheets. Is there a way to find what worksheet and cell reference the ID is located on?

 

[steve the fish]

Yes, but what do you want to do with that information? CNTL-F will help find all instances if you just want to know where they are.

 

[tmitchell52]

I have the ID on one sheet and I need a list of what locations that employee has worked in before. I would like to have the information on one sheet instead of looking it up for each ID each time I need it.

 

[steve the fish]

Ok use CNTL-F then if its for information purposes. Otherwise you need VBA. If you need VBA you need to be a lot more specific on what the data looks like and what you want the end result to look like.

 

[tmitchell52]

There was a post that said you could use this formula: =VLOOKUP(C1,INDIRECT("Sheet"&MATCH(TRUE,COUNTIF(INDIRECT("Sheet"&ROW(INDIRECT("1:10"))&"!A2:A100"),B1)>0,0)&"!A2:B100"),2,0)
I know it said to use a range for the sheets that you are searching and I did but it still would not return a list of the sheet and cell reference.