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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF column contains certain text return value of corresponding row 7
Select rows which satisfy 2 criteria 16
How do I count the number of entries of specifc criteria is met 2
Count values in one column only if criteria is met in the next column. 0
Copy is criteria met 3
if formula - multi criteria 6
Count data in adjacent cell if criteria met 0
Clear contents of cells if a condition is met 2

Back
Top