On Sat, 16 Jul 2005 16:18:01 -0700, "Tankrdav"
wrote:

Thanks ya'all i figured it out
=VLOOKUP("X",A2:D13,4,FALSE) worked

and yes it was that simple lol i just thought it would be alittle more
lengthy

"Tankrdav" wrote:

Column A has either a "/" or "X" in it. if it is an "X" i want what is
contained in Column D for the row with the "X" in in a different cell further
down the sheet.

False forces it to look for an exact match, much like the attribute
'0' when using the MATCH function.
--
"Learning is a behavior that results from consequences."
B.F. Skinner