Sum Based on Lookup

[wsadaqa]

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.

[Excel Fox]

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

[wsadaqa]

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.

[Admin]

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