gwc_excelhelp
New Member
- Joined
- Dec 19, 2016
- Messages
- 3
I am somewhat new to lookup formulas. I have searched online and have been unable to find the right formula that incorporates all of the elements I need to make this work. I'm running out of time for this project, so I thought I would post here to see if anyone can help.
My data is set up like so (this is a sample, my full set includes all 12 months and about 436 rows of data):
<tbody>
</tbody>
What I am looking to do is pull data in the cells to the right of the system name into another tab within this workbook. You can see some cells are blank and some systems have more than one row that contains a sample for the given month. I understand the limitations of vlookup and have experimented with others without any success.
I would like to ignore blank cells so no value will appear if the cell is blank, e.g. not put a zero as the output for a blank cell.
Any insight is much appreciated. Thank you.
<tbody>
</tbody>
My data is set up like so (this is a sample, my full set includes all 12 months and about 436 rows of data):
Area | ID# | Name | January | February | March |
7 | 0000000 | 514 | Bacteria | ||
7 | 0000000 | 514 | Nitrate & Nitrite | ||
5 | 0000000 | Auto Dealer | Bacteria | Bacteria | |
5 | 0000000 | Auto Dealer | Nitrate | ||
2 | 0000000 | Well | Bacteria |
<tbody>
</tbody>
What I am looking to do is pull data in the cells to the right of the system name into another tab within this workbook. You can see some cells are blank and some systems have more than one row that contains a sample for the given month. I understand the limitations of vlookup and have experimented with others without any success.
I would like to ignore blank cells so no value will appear if the cell is blank, e.g. not put a zero as the output for a blank cell.
Any insight is much appreciated. Thank you.
<tbody>
</tbody>