Problem with Excel Formulae

Good morning   I regularly use VLOOKUP to search for a value in a table across a row, however, I now need to identify a value in a row and find the value in the column below it.   I have written ...