Sum Based on Lookup

I am not very advanced in excel and trying to use vlookup to sum two cells.
The value I need to search for is in "Q4". The range I need to lookup the value in is (A4:F100) and indexed on column "A". If value is found then I need cell "S4" to display the sum of O4 and that found in column F (corresponding to the line the value was found in).

Thanks for your assistance.

You mean to say that the value in Q4 may be in any cell in the range A4:F100?

Quote:

---

Originally Posted by Excel Fox

You mean to say that the value in Q4 may be in any cell in the range A4:F100?

---

It is in fact at any place in column "A", but once it's found I need to use the value in "F" of the same row it was found in.

=if(isnumber(match(q4,a4:a100,0)),sumif(a4:a100,q4 ,f4:f100)+o4,"Not Found")