glockgal42
New Member
- Joined
- Dec 15, 2016
- Messages
- 5
So I need to use Index Match and Countblank in order to arrange the number of parking spots I have available by using information from two sheets.
The first sheet (Yard Configurations) is what we use for the arguments:
<colgroup><col style="width:48pt" span="14" width="64"> </colgroup><tbody>
</tbody>
The first sheet (Yard Configurations) is what we use for the arguments:
<tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
IF (H:H, "Yes") & (B:B, "ParkingLocation") Then INDEXMATCH (B:B in "Yard configurations" with A:A in "Data Dump") Finally Countblank (B:B in "Data Dump") If all is true. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
The second sheet (Data Dump):
<tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<colgroup><col style="width:48pt" span="14" width="64"> </colgroup><tbody>
</tbody>