Relate cells

S

surveyorinva

Does anyone know a formula in where
I have 5 columns - Point, N, E, El, Desc are the name of the column
I would like a formula to take the value from a cell under the Point column and run a search for that same value for the entire Desc column. I would like the answer to be either a True or False or (1 or 0

Any help would be great
C. Fillmore
 
L

Lukin

This is probably not the most elegant solution but it does the trick.

Name the range of values in your Desc column 'Desc' and type th
following formula in the cell where you want True or False to appear:

=IF(ISERROR(MATCH(-Cell To Match-,Desc,0)),FALSE,TRUE)

Where -Cell To Match- is the cell in your Point column containing th
value you wish to find in your Desc column
 
J

jeff

Hi,

Assuming your column headings ("point", N,etc) are in
A1-E1 and your data starts A2; try this in, say, G2
and drag down.

=IF(ISERROR(VLOOKUP(A2,E$1:E$6,1,FALSE)),0,1)
or
=IF(ISERROR(VLOOKUP(A2,E$1:E$6,1,FALSE)),"False","True")


jeff
-----Original Message-----
Does anyone know a formula in where:
I have 5 columns - Point, N, E, El, Desc are the name of the columns
I would like a formula to take the value from a cell
Click to expand...
under the Point column and run a search for that same
value for the entire Desc column. I would like the
answer to be either a True or False or (1 or 0)
 
D

Dave Peterson

One more:

=isnumber(match(a1,e:e,0))
for True (if found) or False
or
=--isnumber(match(a1,e:e,0))
for 1/0.
 
Top