Reference a value based on True or False

**GoCards4998** · 05-28-2013, 02:15 PM

Hello All,

Attached is a worksheet I'm having some issues with. I need a formula that will search from C7 to AP7 for those cells that say "True," (and skip over the cells that say "False") then use the $$ amounts below the "True" cells in row 8 to fill out the cells in row 13. I need to be sure that if there are multiple "True" cells, that the second "True" cell will not duplicate the first, and so on. However, it should be noted that the $$ amounts may not be in any sorted order, and can be the same (would still need to be represented even if same number).

Any help would be great. Thanks for taking a look.

**oeldere** · 05-28-2013, 02:48 PM

See the attached file.

With index / match.

I used an helprow (see the yellow cells).

The result is in the green cells.

**GoCards4998** · 05-28-2013, 03:30 PM

I think that did the trick. Thank you for the help, been working on trying to figure that out all day.

Have a good one

**oeldere** · 05-28-2013, 03:57 PM

Thanks for the reply.

But why don't you put the data in columns.

In that case you can just filter the data (which is much easier, as it is an standard solution in Excel).

**GoCards4998** · 06-04-2013, 11:01 AM

The worksheet I used only illustrated what I was attempting to do. I'm working in a much larger functioning workbook that needs to be set a particular way due to government regulations and so just quickly put something together that would illustrate what I was trying to accomplish. Had to modify your work a bit, but you def supplied me what was needed to complete my project.

Thanks again