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.