Excel Search Problem

  • Thread starter Thread starter surveyorinva
  • Start date Start date
S

surveyorinva

I have five columns (A,B,C,D,E) of which I have a varying number of row
per time. Column A will contain numbers from 1+ and Column E wil
contain numbers and text strings. What I want to do is have a colum
E that has a formula that for each row use its corrisponding value in
and search All values in column E for the same value and if that A
contains a value listed in column E somewhere return the label "True
and if not found return "False".
Example
A B C D E F
1 - - - 2000 FALSE
2 - - - 2001 FALSE
2000 - - - STORM TRUE
2001 - - - SAN TRUE
2002 - - - WATER FALSE

Any help would be great Thanks
 
Thanks for the help, I tried it and does not work the way I would like.
I think I am not doing it right, here is the example with data whic
already has been seperated into 5 different columns
A B C D E

1 Point N E Elv Desc <
Just Headers
2 1 - - - 2000
3 2 - - - 2001
4 3 - - - 2003
5 2000 - - - SAN
6 2001 - - - SAN
7 2003 - - - STORM
8 2004 - - - STORM
9 2005 - - - STORM

^- This information is unlimited.
- denotes misc information not needed for this question

In column F2 I tried using the equation: VLOOKUP(A2,A2:E9,5,FALSE) bu
will display whatever information is in column E.

What I want it to do, is take A2 and look through the entire E colum
and if there is a match place some answer in F. So if I take A5, th
formula will run and see that E2 matchs and places some statement
"True" in Cell A5. Now if I put the same formula in F9, it will loo
try to find the value of A9 in column E and not find it and place
statement like "False". Would I use the VLOOKUP for this and am I no
using it right
 
I think you want INDEX and MATCH which is mentioned
near the end of my: (double lookup)
http://www.mvps.org/dmcritchie/excel/vlookup.htm

You can look also for mention of Chip Pearson's pages on the above,
as he has a page devoted to Index and Match.

VLOOKUP is also no good if what you want to use appears
in a column before what you have found as matching the argument.
 
Back
Top