Looking to pull a range of a VLOOKUP if a value exists.
Pull this to a dynamic report from multiple sheets onto one consolidated sheet.
Please see the example:
<tbody>
</tbody>John Snow <--worksheet name
<tbody>
</tbody>Elon Musk <--worksheet name
This is two example sheets of 12 in a workbook.
I need to put the name of the worksheet in a cell; add a few rows for gaps; then bring over the rows with a negative number; few rows, then the new worksheet name; then that sheet's negative values.
The Results would look like this:
<tbody>
</tbody>
Thanks!
Pull this to a dynamic report from multiple sheets onto one consolidated sheet.
Please see the example:
Text | text | text | value to match |
foo | foo | foo | -1 |
bar | bar | bar | 0 |
foobar1 | foobar1 | foobar1 | -2 |
helloworld | helloworld | helloworld | 4 |
<tbody>
</tbody>
text | text | text | value to match |
foobar1 | foobar1 | foobar1 | 3 |
anothervalue | anothervalue | anothervalue | -4 |
something | something | something | 2 |
more | more | more | -2 |
<tbody>
</tbody>
This is two example sheets of 12 in a workbook.
I need to put the name of the worksheet in a cell; add a few rows for gaps; then bring over the rows with a negative number; few rows, then the new worksheet name; then that sheet's negative values.
The Results would look like this:
John Snow | |||
foo | foo | foo | -1 |
foobar1 | foobar1 | foobar1 | -2 |
Elon Musk | |||
anothervalue | anothervalue | anothervalue | -4 |
more | more | more | -2 |
<tbody>
</tbody>
Thanks!