Find a cell in a range

[JohnEOasis]

Hi All,

I need to see if a cell is referanced in a range... ie Cell G32 could be in A1:L50 or G1:G60 of Sheet2 B20:H40. Is there an easy to find these referances vs the trace dependents?

 

[SkipVought]

Hi,

Do you want to know if the cell REFERENCE is in the range or a VALUE?

For th former...
[tt]
=IF(ISERROR(G32 A1:L50 ),1,0)
[/tt]
If there is no intersection, it returns a 1. If there IS an intersection, then it returns a 0.

I have not idea what you mean by "G1:G60 of Sheet2 B20:H40". A range on another sheet would NEVER intersect???


Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[GlennUK]

I think JohnEOasis wants to find out whether cell G32 is references by any formulas in other cells. ( I also have no idea what "G1:G60 of Sheet2 B20:H40" means ).

JohnEOasis: if you are talking about formulas, what are the formulas exactly? Are they direct linking formulas? Or are they lookups? Or what?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[lionelhill]

If this is a one-off manual search, you can just use edit-find. Of course it finds all references within a whole worksheet (or even workbook), so if you want to know of references within a range within a worksheet, the simplest is to copy the relevant range to another sheet (keeping the same location relative to cell A1!). The formulae needn't produce meaningful results in the new sheet, they are merely there to be searched.