How do I loop through each row in this grid and update the price when it finds the “Department” 78102? I found some links when googled but none showed what I was looking for.

Googled and tried several links

ItemNo Department Description StoreNumber Price
1 18331 Home 71832 75.5
2 29653 Lawn 43108 299.95
3 78102 Plumbing 80001
4 44001 Electrical 38913 108.99
5 51836 Wood 41009 39.99