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.