Displayed contents of cell in target row if column criteria is met

[Tankrdav]

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.

[Tankrdav]

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.

[Mangus Pyke]

On Sat, 16 Jul 2005 16:18:01 -0700, "Tankrdav"
<[email protected]> 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