Formula to Match value over multiple worksheets

[baked_dog]

Hi,

I have an excel file with several worksheets, (ie Sheet1, Sheet2 ..all the way to Sheet50)

I want to create a new sheet (Sheet51) and in this use a formula to find a match for a particular value (say 10) in position G18 on all the sheets.

Is there a formula to do this?

Any help would be greatly appreciated.

Cheers

[Fotis1991]

Hi

See a perfect example of this

3D-VLOOKUP.xls. in Jerry's site.

https://sites.google.com/a/madrocket...ssistant/files