A B C D
1 Kevin P 320 ME #1 10.0
2 Kevin 350 NVT 10.0
3 Dennis M 325 SNH/NNH Day #1 10.0
4 Steve P 300 BOS/LCL 9.0
5 Mike C 260 WOR [Trac] 9.0
6 Tom 300 ALB 8.0
7 Mike D 200 WCT [Trac] 8.0
8 Laszlo 280 RHN [Trac] 8.0
9 Dennis M (Unload) BAEC '09 Show 2.0
10 Greg S (Load) 20th Annual Hudson HS 1.0

What function would I use for the following statement: If specific text is
found in the range A2:A10 then follow the row of that cell and report the
amount shown in column D