If you have drop down boxes, you will want to ensure that the values are set in cells. If the drop down is from data validation then this is OK - otherwise you will need to use the INDEX function on the source range of a the form object cell link from what has been chosen.
The CONCATENATE function can then be used inside a VLOOKUP function to return the match in the column Q. Be sure to use the option FALSE at the end to return exact matches only (not the closest with option TRUE).
