-2

I have one value in say 'Sheet2'. I have to find out the cell reference from all the values in say 'Sheet1'. Please answer quick, it may be easy but I need quick help on this.

Money Khanna
  • 1
  • 1
  • What exactly you want? Explain with example. – Paresh J Nov 10 '14 at 07:00
  • see http://stackoverflow.com/questions/7152934/excel-search-for-cell-references-in-formulas and http://stackoverflow.com/questions/17787486/excel-formula-to-find-reference-used-by-other-cell and http://stackoverflow.com/questions/14248820/find-all-references-to-a-cell. BTW, search before ask & ask in detail in future to get prompt and good answer. – ZAT Nov 10 '14 at 08:02

1 Answers1

0

Use menu Formulas / Trace Dependents. Then follow the blue arrows to find the referenced cells.

P.S. "Please answer quick, it may be easy but I need quick help on this." is not encouraging. Welcome to StackOverflow.

ttaaoossuuuu
  • 7,786
  • 3
  • 28
  • 58