Hi All,
I can't figure out how to word this to search properly, so I haven't found something even though I'm sure someone's posted this before...
I'm in the process of converting a list to a grid, based on the values in the grid. I've done this before matching 1 criteria, but having trouble matching to two criteria. Here's what I mean:
List:
<tbody>
</tbody>
Converting to Grid:
<tbody>
</tbody>
Very simple example, but essentially, I need the macro to loop over my list, and place the value in column 3 into by grid, based on looking up the 2-row headers.
If you can just help me identify the column number, I can do the rest. I have 99% of my macro built (much more complex than this), but just trying to figure out how to match a column based on 2 criteria.
Thoughts?
Thanks!
Alex
(Excel 2016)
I can't figure out how to word this to search properly, so I haven't found something even though I'm sure someone's posted this before...
I'm in the process of converting a list to a grid, based on the values in the grid. I've done this before matching 1 criteria, but having trouble matching to two criteria. Here's what I mean:
List:
Fruit | Apple | 50 |
Fruit | Pear | 20 |
Veggie | Carrot | 10 |
Veggie | Kale | 25 |
<tbody>
</tbody>
Converting to Grid:
Fruit | Fruit | Fruit | Veggie | Veggie | Carb |
Pear | Apple | Orange | Carrot | Kale | Pasta |
20 | 50 | 10 | 25 |
<tbody>
</tbody>
Very simple example, but essentially, I need the macro to loop over my list, and place the value in column 3 into by grid, based on looking up the 2-row headers.
If you can just help me identify the column number, I can do the rest. I have 99% of my macro built (much more complex than this), but just trying to figure out how to match a column based on 2 criteria.
Thoughts?
Thanks!
Alex
(Excel 2016)