| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Displayed contents of cell in target row if column criteria is met
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a empty cell in next column | Excel Discussion (Misc queries) | |||
| Copy one cell to entire column | Excel Discussion (Misc queries) | |||
| How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
| same cell from multiple sheets into one column | Excel Discussion (Misc queries) | |||
| Copying the contents of a column into a chart | Excel Worksheet Functions | |||
Hybrid Mode
