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

T

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.
 
T

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
 
M

Mangus Pyke

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
Click to expand...

False forces it to look for an exact match, much like the attribute
'0' when using the MATCH function.
 
Top